Getting Rows in a Table in Random Order in MS SQL

192 Reads Ms Sql

In MS SQL Server, the following procedure is followed to randomly fetch all records in a table.

SELECT * FROM {Table Name} ORDER BY NEWID()
Ms Sql

You May Interest

How to Learn MS SQL Server Version

What is the Difference Between Update Lock and Exclusive Lock in ...

What are Isolation Levels in SQL Server ?

What is Blocking in SQL Server ?

What is the Difference Between Clustered and a Non-clustered Inde ...