从数据库表中随机获取N条记录的SQL语句
摘要：
Oracle: select * from (select * from tableName order by dbms_random.value) where rownum < N MS SQLServer: select top N * from tableName order by newid 阅读全文
posted @ 2019-02-26 13:09 乌云上 阅读(594) 评论(0) 推荐(0) 编辑
