Query Random Row pada Database



Beikut adalah contoh Query Random Row pada database :

1. MySQL :

SELECT column FROM table

ORDER BY RAND()

LIMIT 1


2.  PostgreSQL :

SELECT column FROM table

ORDER BY RANDOM()

LIMIT 1


3.  SQL Server :

SELECT TOP 1 column FROM table

ORDER BY NEWID()


4.  IBM DB2 :

SELECT column,  RAND() as IDX 

FROM table 

ORDER BY IDX FETCH FIRST 1 ROWS ONLY


5.  Oracle :

SELECT column FROM

( SELECT column FROM table

ORDER BY dbms_random.value )

WHERE rownum = 1