CodePaste Logo
New Snippet New Snippet Recent Snippets Recent Snippets My Snippets My Snippets Web Code Search Snippets Search
Sign inor Register
Language: SQL

Selecting Random records in SQL Server

200 Views
Copy Code Show/Hide Line Numbers
SELECT TOP {#} {Fields} 
FROM {table} 
ORDER BY newid()
by kopelli
  December 31, 2009 @ 1:55pm
Tags:

Add a comment


Report Abuse
brought to you by:
West Wind Techologies



If you find this site useful and use it frequently please consider making a donation to support this free service.
Donate