Page 1 of 1

SQL query, group, random

Posted: Tue Mar 08, 2005 6:36 pm
by Shendemiar
Is it possible to write a query that returns records just by normal ORDER BY, but if the asked value is same between many records, it randomizes the order of these.

Posted: Tue Mar 08, 2005 6:42 pm
by feyd
I don't understand. :?

Posted: Tue Mar 08, 2005 7:30 pm
by magicrobotmonkey
try

Code: Select all

ORDER BY Column_Name, RAND()