Using NEWID to randomly sort the records

 

SqlServer offers a strong method to select the rows randomly from a table. It is very easy, simple and useful too.

Solution :

SELECT * FROM Orders ORDER BY NEWID()