1、方式一 以row_number函数为基础
select * from
(
select row_number() over (order by colName) as rowNum,* from tableName
) as t
where rowNum between 10 and 20 -- 从第10行到第20行,共11条记录
2、方式二 使用 top n关键字
select top 10 * from tableName
where tableId not in
(
select top 20 tableId from tableName
)