SQL 检索出指定的行数

例如从表“Tabel1”中安升序检索"id"，仅输出结果的第11-20行

SELECt TOP 20 *
FROM Tabel1
WHERe (ID NOT IN
    (SELECt TOP 10 id
    FROM Tabel1 ORDER BY ID))

ORDER BY ID

如果你使用的是sqlserver2005或者以上版本，可以使用以下语句：

SELECt * FROM (select *,ROW_NUMBER() Over(order by id asc) as rowNum from Tabel1  where 1=1) as myTable   where rowNum between 11 and 20

注：ROW_NUMBER() Over(order by id asc) 是sqlserver2005新加的功能

Select Top 10 * From Table Where id Not In (Select Top 10 id From Table)

select top 10 * from table1 where id not in(select top 10 id from table1 order by id) order by id