SQL SQL Server

How to return records in random order in Stored Procedure

Here is simple example to return records in Random Order.   Example if you have rank 1,2,3,4,5…. Instead of using rank field in Ascending or descending order you wish you return in Random order use newid as shown below


About the author


Leave a Comment