Skip to content

Instantly share code, notes, and snippets.

@Erreinion
Created July 17, 2013 16:21
Show Gist options
  • Save Erreinion/6022121 to your computer and use it in GitHub Desktop.
Save Erreinion/6022121 to your computer and use it in GitHub Desktop.
Get 10 random records from SQL - different set of 10 every time it is run.
SELECT TOP 10 *
FROM Table
ORDER BY NEWID()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment