如果有id
select * from mydb where id between 10 and 11如果沒有id 有主鍵
select * from (select top 11 * from mydb) a where
主鍵 not in(select top 10 主鍵 from mydb)
select * from mydb where id between 10 and 11如果沒有id 有主鍵
select * from (select top 11 * from mydb) a where
主鍵 not in(select top 10 主鍵 from mydb)
SELECT * FROM #T WHERE Id BETWEEN 11 AND 20
DROP TABLE #T