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