Getting A Random Row From A MS SQL Table

9th January 2008

To get a random row from a Microsoft SQL database you need to use the NEWID() function. This will generate a new random number for each row and order them by that new number. This is used in conjunction with the TOP clause to limit the amount of returned rows to one.

SELECT TOP 1 VALUE FROM TABLE ORDER BY NEWID()

 

Add new comment

The content of this field is kept private and will not be shown publicly.