January 5, 2015 by pramod thakur in SQL
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()
I hope this code is helpful.
Happy coding 🙂
Tags: random row in sql server