categoryID, sortOrder
1, 1
1, 2
1, 3
2, 4
2, 5
1, 6

What would my sql statement be if I wanted to gather all data grouped by category but in sort Order... for a resulting recordset of...

categoryID, sortOrder
1, 1
1, 2
1, 3
1, 6
2, 4
2, 5

Thanks