Returning a Random set of Records

Execute the following query in the AdventureWorks database:

select top 5 productid, name from production.product
order by newid()

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)

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)