table
---------------------
id,category,record
1,love,my record title
2,love,my record title 2
3,fun,my record title 3
4,sports,my record title 4
5,sports,my record title 5
6,fun,my record title 6
7,love,my record title 7
8,sport,my record title 8
9,sport,my record title 8
i am trying to select top 5 unique records from this table.
table has 4 sport, 3 love and 2 fun category
so when query runs it would only select one of each category from top
ten records ordered by id
can anyone give me some help?