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.