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