Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
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
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap