[Home]  [Edit this page]  [Recent Changes]  [Special Pages]  [Help
SqlGetOneRandomRow

(SQL) Get one random row

See also get one row.

From http://www.petefreitag.com/item/466.cfm this addition:

MySQL

SELECT * FROM database
ORDER BY RAND()
LIMIT 1


PostgreSQL

SELECT column FROM table
ORDER BY RANDOM()
LIMIT 1


Microsoft SQL Server

SELECT TOP 1 column FROM table
ORDER BY NEWID()


IBM DB2

SELECT column FROM table
ORDER BY RAND()
FETCH FIRST 1 ROWS ONLY


Oracle

SELECT column FROM
( SELECT column FROM table
ORDER BY dbms_random.value )
WHERE rownum = 1


last edited (December 14, 2006) by bilderbikkel, Number of views: 494, Current Rev: 1

[Edit this page]  [Page history]  [What links here]  [Discuss this topic]  [Printer Friendly]  

Members

Username:

Password:


Register
Forgot Password?




Programmers Heaven - for .NET, Java, C/C++ and WEB Developers!
© 1996-2008 Community Networks Ltd. All rights reserved. Reproduction in whole or in part, in any form or medium without express written permission is prohibited. Violators of this policy may be subject to legal action. Please read Terms Of Use and Privacy Statement for more information. Development by Tore Nestenius at .NET Consultant - Synchron Data.