Select Random dari Tabel

Berikut ini beberapa query yang bisa anda praktekan  apabila anda ingin memunculkan data acak dari table












1. Database MySQL:

SELECT column FROM table ORDER BY RAND() LIMIT 1

2. Database PostgreSQL:

SELECT column FROM table ORDER BY RANDOM() LIMIT 1

3. Database Microsoft SQL Server:

SELECT TOP 1 column FROM table ORDER BY NEWID()

4. Database IBM DB2:

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

5. Database Oracle:

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