Random sort in T-SQL
Recently I had a task to return rows from a SQL Server database in random order.
Here is a simple solution:
SELECT * FROM MyTable ORDER BY newid()
Potential applications include selecting a random tip of the day or a random product of the day for any portal/online shop/etc, which is now simple enough by typing the following:
SELECT TOP 1 * FROM MyTable ORDER BY newid()
