Conditional Random Order
Posted: Wed Jul 18, 2007 5:30 pm
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
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