Select a random row with MySQL:
If you want to return a random row with MY SQL, use the following syntax:
SELECT column FROM table ORDER BY RAND () LIMIT 1;
Select a random row with Postgre SQL:
SELECT column FROM table ORDER BY RANDOM () LIMIT 1;
Select a random row with SQL Server:
SELECT TOP 1 column FROM table ORDER BY NEWID ();
Select a random row with oracle:
SELECT column FROM (SELECT column FROM table ORDER BY dbms_random.value) WHERE rownum = 1;
Select a random row with IBM DB2:
SELECT column RAND () as IDX FROM table ORDER BY IDX FETCH FIRST 1 ROWS ONLY;