How to select a random row in SQL

23rd September 2019 posted in SQL

Home > SQL > How to select a random row in SQL

Select a random row with Microsoft SQL

select top 1 column from your_table order by NEWID()

Select a random row with MySQL

SELECT column FROM table ORDER BY RAND() LIMIT 1

Select a random row with PostgreSQL

SELECT column FROM table ORDER BY RANDOM() LIMIT 1

Select a random row with IBM DB2

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

Select a random row with Oracle

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

Tags: sql