SQL 隨機取出資料表格內容

MySQL︰
<br />SELECT column_name <br />FROM table_name<br />ORDER BY RAND()<br />LIMIT 1<br />
PostgreSQL︰
<br />SELECT column_name FROM table_name<br />ORDER BY RANDOM()<br />LIMIT 1<br />
Microsoft SQL Server︰
<br />SELECT TOP 1 column_name FROM table_name<br />ORDER BY NEWID()<br />
Oracle︰
<br />SELECT column_name FROM<br />( SELECT column_name <br /> FROM table_name <br /> ORDER BY dbms_random.value )<br />WHERE rownum = 1<br />
IBM DB2︰
<br />SELECT column_name, RAND() as IDX<br />FROM table_name<br />ORDER BY IDX FETCH FIRST 1 ROWS ONLY<br />

資料來源︰
SQL to Select a random row from a database table