Tuesday, 16 June 2009

How to Select Data in Random Order in SQL Server

In number of scenarios we might want to do data sampling or select the data in a Random Order. SQL Server supports various options for data sampling. I have given some of the examples here

Using NEWID() :
SELECT TOP 10 ForeName
FROM Patient
ORDER BY NEWID()


Using PERCENT
SELECT TOP 10 ForeName
FROM (SELECT TOP 30 PERCENT ForeName
FROM Patient
ORDER BY ForeName ASC) AS Pat
ORDER BY 1 DESC

5 comments:

  1. replica bags hong kong gucci fake n9m76p2c21 replica bags qatar replica bags koh samui helpful hints e7q59a7w76 replica bags los angeles find more info l0t60t0k80 replica louis vuitton bags 9a replica bags

    ReplyDelete