Sort randomly
To sort radomly every time you run the query, use this method,
SELECT columnname1, columnname2 FROM YOURTABLE ORDER BY NEWID()
To sort radomly every time you run the query, use this method,
SELECT columnname1, columnname2 FROM YOURTABLE ORDER BY NEWID()
Posted by Guru Prasath at 11:55 pm
No comments:
Post a Comment