Random records from table
Hi all,
Great to be part of this blogging community. I will try to submit several posts each week and will make sure they contain snippets of code here and there.
Now, what would you do to select a random set of several records from a SQL Server database table?
A couple of months ago I came across the following simple, but yet very effective solution to do just that. For instance to get 10 random quotes from a Quotes table:
SELECT TOP 10 * FROM Quotes ORDER BY NEWID()
Personally I think it's pure gold.