to andymu077() : 你有感觉到明显很慢吗?能否给出测试数据?总记录数: 查询语句: 时间: 机器配置:盼各位达人解惑 . . .
select * from (select top 20 * from (SELECT top 200000 FROM MyTable order by Id) TBL order by Id desc ) TBL2 order by Id这样也可以的哟select top 20 * from (SELECT top 200000 FROM MyTable order by Id) TBL order by Id desc
查询语句:
时间:
机器配置:盼各位达人解惑 . . .