Getting Rows in a Table in Random Order in MS SQL

206 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 Show Line Numbers in MS SQL Server ?

What is Deadlock in SQL Server ?

What is a View in SQL Server ?

What are The Different Backup Options With SQL Server ?

What are the Different Recovery Models Inside SQL Server ?