Randomize Query in SQL - SQL Snipplr Social Repository

Revision: 12395

at March 12, 2009 17:21 by blackf0rk

Initial Code

SELECT TOP 10 * FROM [someTable] ORDER BY NEWID()

Initial URL

http://codefinds.blogspot.com/2008/08/randomize-query-in-sql.html

Initial Description

Sometimes you want to return a bunch of data from a table, but you want it coming back in a random order. Maybe it's for keeping some content on a home page fresh. Here's how:

Initial Title

Randomize Query in SQL

Initial Tags

sql

Initial Language

SQL

Choose a language for easy browsing: