2006-09-14

Random Selects

The simple things are often the best. Like this way of selecting a random row from a table.

SELECT *
FROM MyTable
ORDER BY NEWID()

No comments: