MS SQL Getting a Random Row in a Table

176 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

Getting List of System Hard Disks with Free Space in MS SQL Serve ...

Creating a View in MS SQL

What is Blocking in SQL Server ?

Getting Character Count in MS SQL

How to Rebuild the Master Database in SQL Server ?