Wednesday, April 27, 2005

Sort randomly

To sort radomly every time you run the query, use this method,

SELECT columnname1, columnname2 FROM YOURTABLE ORDER BY NEWID()

No comments: