各個數據庫獲取隨機列的語法 [html] 各個數據庫獲取隨機列的語法 MySQL SELECT column FROM table ORDER BY RAND() LIMIT 10 Oracle SELECT column FROM( SELECT column FROM table ORDER BY dbms_random.value ) WHERE rownum <= 10 PostgreSQL SELECT column FROM table ORDER BY RANDOM() LIMIT 10 SQL Server SELECT TOP 10 column FROM table ORDER BY NEWID()