求一个sql语句

Question

从表A中提取第10到第20行数据，id可能是不连续的。。。求这个sql语句……

Answer 1

select * from (

    select *, ROW_NUMBER() RN

    from A

) where RN between 10 and 20

Answer 2

select top 10 * from A where id not in (select top 9 id from A)