Daily Archives: 12/02/2006

SQL to Select a Random Row

MySQL:[code=sql]SELECT column FROM table ORDER BY RAND() LIMIT 1[/code]
PostgreSQL:[code=sql]SELECT column FROM table ORDER BY RANDOM() LIMIT 1[/code]
Microsoft SQL Server:[code=sql]SELECT TOP 1 column FROM table ORDER BY NEWID() [/code]
IBM DB2:[code=sql]SELECT column FROM table ORDER BY RAND() FETCH FIRST 1 ROWS ONLY[/code]
Oracle:[code=sql]SELECT column FROM
( SELECT column FROM table
ORDER BY dbms_random.value )
WHERE rownum = 1[/code]