MS SQL Getting a Random Row in a Table

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()


You May Interest

MS SQL Finding Which Tables a Column Name is In

What is the Maximum Size per Database for SQL Server Express ?

What are OFFLINE Datafiles with SQL Server ?

What is CTE in SQL Server ?

Showing Server Active Server Name in MS SQL