Do you want to return rows sorted in random order , here’s how you do it.
How to return rows in random order in SQL Server ?
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())