Het ophalen van willekeurige rijen uit een database.Ieder systeem heeft zijn eigen manier van aanroep:Select a random row with MySQL:SELECT column FROM tableORDER BY RAND()LIMIT 1
Select a random row with PostgreSQL:SELECT column FROM tableORDER BY RANDOM()LIMIT 1
Select a random row with Microsoft SQL Server:SELECT TOP 1 column FROM tableORDER BY NEWID()Select a random row with IBM DB2SELECT column, RAND() as IDX FROM table ORDER BY IDX FETCH FIRST 1 ROWS ONLY
Select a random record with Oracle:SELECT column FROM( SELECT column FROM tableORDER BY dbms_random.value )WHERE rownum = 1