MS SQL Getting a Random Row in a Table

215 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

Using CASE WHEN in MS SQL

MS SQL Finding Which Tables a Column Name is In

What is the Difference Between CHAR and VARCHAR Datatypes in SQL ...

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

What is a View in SQL Server ?