[Home]
[Edit this page]
[Recent Changes]
[Special Pages]
[Help]
SqlGetOneRandomRow
From http://www.petefreitag.com/item/466.cfm this addition:
[Edit this page] [Page history] [What links here] [Discuss this topic] [Printer Friendly]
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
[Edit this page] [Page history] [What links here] [Discuss this topic] [Printer Friendly]
