比如:要求选取 tbllendlist 中 第3000页的记录,每一页100条记录。 ---------- 方法1: ---------- select top 100 * from tbllendlist where fldserialNo not in ( select top 300100 fldserialNo from tbllendlist order by fldserialNo ) order by fldserialNo ---------- 方法2: ---------- SELECT TOP 100 * FROM tbllendlist WHERE (fldserialNo > (SELECT MAX(fldserialNo) FROM (SELECT TOP 300100 fldserialNo FROM tbllendlist ORDER BY fldserialNo) AS T)) ORDER BY fldserialNo 方法1执行速度比较快! 不过,这种做法还是很麻烦,强烈期待微软发明新的可分页的SQL语句来!!!! |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 17:33 , Processed in 0.290442 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.