SELECT RANDOM ROW - SQL Snipplr Social Repository

Revision: 36122

at November 18, 2010 07:22 by vedgiee

Initial Code

SELECT TOP 10 PERCENT *
  FROM tablename
  ORDER BY NEWID()

Initial URL

Initial Description

MS SQL Select a Random Row with NEWID()

Initial Title

SELECT RANDOM ROW

Initial Tags

Initial Language

SQL