stored procedure

now browsing by tag

 
 

SQL Tip: Select a random row from a SQL database table

So how do you select a random row in a SQL database table?

SELECT TOP 1 Name, Address, City
FROM         tbl_Person
ORDER BY NEWID()

This will select a random person every time.