MS SQL Getting a Random Row in a Table

194 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

Deleting Table With Query in MS SQL

MS SQL Getting List of All Column Names of a Table

What are the Different Recovery Models Inside SQL Server ?

Using MS SQL If Else

Where are SQL Server Usernames and Passwords Stored in the SQL Se ...