Top N rows for each X

(Rudy Limeback) I want a query for retrieving the top two recently inserted records for each id. My table has columns id, adate, and description. There are five records with id 2 and four records with id 3. I want to retrieve top two records for both id 2 and 3. I should get total four records,

Read More - Register for Free Membership