MS SQL Getting a Random Row in a Table

42 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

What is Change Data Capture in SQL Server ?

Changing MS SQL Table Name with Query

What is Deadlock in SQL Server ?

What is the Difference Between VARCHAR and NVARCHAR in SQL Server ...

Disabling a Specified Trigger in MS SQL Server