MS SQL Getting a Random Row in a Table

25 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 the Maximum Size per Database for SQL Server Express ?

Getting List of All Stored Procedures in Database in MS SQL

What is Auditing Inside SQL Server ?

What Have INCLUDED Columns With SQL Server Indexes ?

What is the Maximum Number of Columns a Table in SQL Server ?