Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1st random querry = get 10 random rows
- 2nd random querry = get another 10 random rows different from the 1st call
- .
- .
- .
- 10th random querry = get the last 10 rows not choosen
- SELECT TOP 10 [your select list)
- FROM [your table]
- ORDER BY NEWID()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement