Can i order the query so that i would get all of certain value at first, and the all the rest in random order?
Example
AAA, BBB, CCC (Column names and the below are the rows)
2,1,1
2,2,2
2,3,3
1,1,1
1,2,2
1,3,3
3,1,1
3,2,2
3,3,3
And the query would give
1,1,1
1,2,2
1,3,3
And then the rest in random order
Conditional Random Order
Moderator: General Moderators
-
Shendemiar
- Forum Contributor
- Posts: 404
- Joined: Thu Jan 08, 2004 8:28 am