How to get random row in SQL Server

Pramod Thakur

12y1.5kCode

In this code snippet we learn who to get random row in sql server.

We can find the random row by using newid() function in sql.

I am using sql server 2012 and ReportServer database.

select top 1 * from DBUpgradeHistory order by NEWID()