09 2017 档案

四种数据库随机获取N条数据的方法
摘要：1.SQL Server: SELECT TOP n * FROM tableName ORDER BY NEWID(); 2.ORACLE: SELECT * FROM (SELECT * FROM tableName ORDER BY DBMS_RANDOM.RANDOM()) WHERE RO 阅读全文
posted @ 2017-09-06 09:54 orac 阅读(1518) 评论(0) 推荐(0)