摘要: --sql server 随机读取数据 SELECT TOP 1 * FROM [tablename] ORDER BY NEWID() SELECT * FROM [tablename] where pk in (select top 1 pk from [tablename] ORDER BY NEWID()) --这两个方法都需要排序,因此IO的逻辑读取会比较多,而且CPU占用也多很... 阅读全文
posted @ 2016-11-03 18:10 davidhou 阅读(3644) 评论(0) 推荐(0)