Getting Rows in a Table in Random Order in MS SQL

175 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

What is CTE in SQL Server ?

What is the XML Datatype in SQL Server ?

What is a Linked Server in SQL Server ?

MS SQL Getting List of All Column Names of a Table

MS SQL Getting a Random Row in a Table