Ian 懶惰蟲筆記
2008年5月21日 星期三
SQL 隨機取出資料表格內容
MySQL︰
SELECT column_name
FROM table_name
ORDER BY RAND()
LIMIT 1
PostgreSQL︰
SELECT column_name FROM table_name
ORDER BY RANDOM()
LIMIT 1
Microsoft SQL Server︰
SELECT TOP 1 column_name FROM table_name
ORDER BY NEWID()
Oracle︰
SELECT column_name FROM
( SELECT column_name
FROM table_name
ORDER BY dbms_random.value )
WHERE rownum = 1
IBM DB2︰
SELECT column_name, RAND() as IDX
FROM table_name
ORDER BY IDX FETCH FIRST 1 ROWS ONLY
資料來源︰
SQL to Select a random row from a database table
沒有留言:
張貼留言
‹
›
首頁
查看網路版
沒有留言:
張貼留言