MS SQL Getting a Random Row in a Table

175 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

List of Table Columns Used in Any View in MS SQL

What is the Merge Statement in SQL Server ?

What is The Concept of Piecemeal Restore on SQL Server ?

MS SQL List of Records in All Tables

What is SQL Server Agent ?