1: select count(*) from Order 结果：49900 条数据 ，共执行0秒2：SELECT * FROM Order 共执行4秒3： select * from( SELECT row_number() over( order by ID) as rownum,* FROM Order ) t where t.rownum >=48000 and t.rownum<=49900 共执行0秒4： select * from Order where OrderFormID = 48007 执行0秒5： select * from Order where LMSw Read More
