please help to build the qry

See more:

SQL-Server

categoryid url count
3 url3new 45
1 url1 50
2 url2 55
3 url3 45
4 url4 53
5 url5 97
6 url6 47
1 url1new 50
2 url2new 55
5 url5new 97
4 url4new 53
6 url6nw 47

i got a record when i fired certain qry in sql
now i want further ordering based on top 5-5 groups of distinct categoryid
order by count

so result shoul look like

categoryid url count
5 url5 97
2 url2 55
4 url4 53
1 url1 50
6 url6nw 47
3 url3new 45

5 url5new 97
2 url2new 55
4 url4new 53
1 url1new 50
6 url6 47
3 url3 45

group top distinct 5 category order by count
again same cycle should repeat

many thanks