各个数据库获取随机列的语法
原文链接:http://www.javaarch.net/jiagoushi/703.htm
各个数据库获取随机列的语法 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()