各个数据库获取随机列的语法_MySQL

各个数据库获取随机列的语法

[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()