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

来源:互联网 发布:智能推荐系统书籍 知乎 编辑:程序博客网 时间:2024/05/19 12:14

原文链接:http://www.javaarch.net/jiagoushi/703.htm

各个数据库获取随机列的语法MySQLSELECT column FROM table ORDER BY RAND() LIMIT 10OracleSELECT column FROM( SELECT column FROM table ORDER BY dbms_random.value ) WHERE rownum <= 10PostgreSQLSELECT column FROM table ORDER BY RANDOM() LIMIT 10SQL ServerSELECT TOP 10 column FROM table ORDER BY NEWID()


原创粉丝点击