MS SQL Getting a Random Row in a Table

22 Reads Ms Sql

If we want to fetch a random row in a table in MS SQL Server, the following path is followed.

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

You May Interest

Disabling All Constants in a Table in MS SQL

What are the Different Recovery Models Inside SQL Server ?

What are the INTERSECT Operators in SQL Server ?

What is the XML Datatype in SQL Server ?

What is the Difference Between a Local and a Global Temporary Tab ...