How to return rows in random order in SQL Server ?

Do you want to return rows sorted in random order , here’s how you do it.

This example demonstrates how to sort the Employee table and display the results in random order.

Use AdventureWorks2014
GO
SELECT 
    * 
FROM 
    HumanResources.Employee
ORDER BY 
    CHECKSUM(NEWID())

Tags : How to, SQL Server, tips, tricks

Abundant Code