SQL query, group, random
Moderator: General Moderators
-
Shendemiar
- Forum Contributor
- Posts: 404
- Joined: Thu Jan 08, 2004 8:28 am
SQL query, group, random
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.
-
magicrobotmonkey
- Forum Regular
- Posts: 888
- Joined: Sun Mar 21, 2004 1:09 pm
- Location: Cambridge, MA
try
Code: Select all
ORDER BY Column_Name, RAND()