Pick top 5 from data

[dassuz]

Hi I have a table with hundreds of line of data which has been sorted by username and date1. I want to bring back the top 5 records for each username. What is the best way to do this in a query. Example data is the attachment with the way I would like the data to look once its complete

 

[MajP]

Several methods explained here
https://en.wikibooks.org/wiki/Structured_Query_Language/Retrieve_Top_N_Rows_per_Group

 

[theDBguy]

Hi. Welcome to AWF! Here's one more link for the same thing.

 

[arnelgp]

is that that field from a query?

use this query against that query:

select queryName.* from queryName 
where  
     (select count("1") from queryName as t1 
           where t1.username=queryName.username and 
           t1.mydatefield>= queryName.mydatefield) < 6;