SELECT TOP 1 column FROM table
ORDER BY NEWID()
More ways to get random rows on other databases can be seen here.
As well as another article on random rows on SQL Server.
Showing posts with label server. Show all posts
Showing posts with label server. Show all posts
Monday, March 5, 2012
Get a random row on SQL Server
Pretty simple method for getting a random row on SQL Server.
More ways to get random rows on other databases can be seen here.
As well as another article on random rows on SQL Server.
More ways to get random rows on other databases can be seen here.
As well as another article on random rows on SQL Server.
Subscribe to:
Posts (Atom)