How to select random row from a data table
2009-05-13
1: Select a random row with Microsoft SQL Server:
SELECT TOP 1 column FROM table ORDER BY NEWID()
2: Select a random record with Oracle:
SELECT column FROM ( SELECT column FROM table ORDER BY dbms_random.value ) WHERE rownum = 1
3: Select a random row with MySQL:
SELECT column FROM table ORDER BY RAND() LIMIT 1
4: Select a random row with PostgreSQL:
SELECT column FROM table ORDER BY RANDOM() LIMIT 1
5: Select a random row with IBM DB2
SELECT column, RAND() as IDX FROM table ORDER BY IDX FETCH FIRST 1 ROWS ONLY