TopValues

[Cmacvp16]

I am trying to query a table with monthly values over a year.

I need to return the Top 5 values in each month (60 records). Instead I am return the Top 5 values for the whole year (5 records).

Do I need to run 5 seperate queries or can this be done in one?

 

[Fornatian]

http://support.microsoft.com/default.aspx?scid=kb;en-us;153747