I have a table of people with their commments on a blog . I need to leave the last 10 comments for each person in the table and delete the older ones. Lets say the columns are: personId commentId dateFromComment I know how to do it with several queries but not with just one query(any subqueries allowed) and for anyDatabase