我任何写sql语句实现查询第10条到第20条数据！？

[liujian098]

如题~谢谢！

[liujian098]

如何写？

[zyddamon]

select * from user_infor where id between 9 and 21

[zly22169846]

前提你先要有一个自动增长的ID号，
select top 11 * from table where id not in (select top 9 id from table)

[tianhao86]

sql="select top 10 * from (select top 20 * from xx ) order by id desc"

[zyddamon]

也可以用in (不知道具体数目的情况下)

[liujian098]

我记得还有别的方法吧~可是我一时想不起来！

[tianhao86]

zyddamon(狗尾巴草）
如果id小于20的都被删除了怎么办

[tianhao86]

用我的方法刚测试通过

[comszsoft]

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