RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL
Expertise: Advanced
Apr 10, 2007

Returning a Random set of Records

The NEWID() function returns a uniqueidentifier for each row of data that is returned.

Execute the following query in the AdventureWorks database:

select top 5 productid, name from production.product
order by newid()
Here are the results:

productid   name
----------- --------------------------------------------------
917         LL Mountain Frame - Silver, 42
722         LL Road Frame - Black, 58
372         Thin-Jam Hex Nut 8
969         Touring-1000 Blue, 60
328         Mountain End Caps

(5 row(s) affected)
Execute the query again and you get a completely different set of results:

productid   name
----------- --------------------------------------------------
861         Full-Finger Gloves, S
440         Lock Nut 16
526         HL Shell
451         Lock Nut 11
406         External Lock Washer 5

(5 row(s) affected)
Parthasarathy Mandayam
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date