(1) select * from tab where id>=10 and id<=11
还有一种是根据排序加top来写的,不过我怎么写都不对也不知道什么原因,先写下,啥时候再改改
(2)select top 2 * from (select top 9 * from tab order by id desc) as tmp order by id asc
(3) select top 10 * from tab where id in (select top 40 * from tab )