Sort table rows randomly in SQL Server

 

SELECT * FROM table
ORDER BY NEWID()

In the above example NEWID() creates a unique value of type uniqueidentifier for each row and sort the rows accordingly.

Below is the example for retrieving a single random record from a table

SELECT TOP 1 * FROM table
ORDER BY NEWID()

Happy coding…