SQL SQL Server

How to return records in random order in Stored Procedure1 min read

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


Leave a Comment