随机选择行的SQL语句? ORACLE SQLSERVER ECT.

MySQL:

SELECT column FROM tableORDER BY RAND()LIMIT 1

PostgreSQL:

SELECT column FROM tableORDER BY RANDOM()LIMIT 1

Microsoft SQL Server:

SELECT TOP 1 column FROM tableORDER BY NEWID()

IBM DB2

SELECT column, RAND() as IDX FROM table ORDER BY IDX FETCH FIRST 1 ROWS ONLY

Oracle:

SELECT column FROM( SELECT column FROM tableORDER BY dbms_random.value )WHERE rownum = 1