各大數據庫隨機選取n條數據的SQL語句

Select a random row with MySQL:
Select column FROM table
orDER BY RAND()
LIMIT 1

Select a random row with PostgreSQL:
Select column FROM table
orDER BY RANDOM()
LIMIT 1

Select a random row with Microsoft SQL Server:
Select TOP 1 column FROM table
orDER BY NEWID()

Select a random row with IBM DB2
Select column, RAND() as IDX
FROM table
orDER BY IDX FETCH FIRST 1 ROWS ONLY
Thanks Tim

Select a random record with oracle:

Select column FROM
( Select column FROM table
orDER BY dbms_random.value )
Where rownum = 1

[本日志由 wbc 于 2009-04-02 10:31 PM 编辑]
文章來自: Intranets
引用通告地址: http://www.bkkss.com/trackback.asp?tbID=420
日志標簽: sqlsql