How to get a random record using MSSQL

Comments | Share

This is a very short post. so bear with me.

SELECT *
FROM Northwind..Orders 
ORDER BY NEWID()

The Magic here is NewID()