select top 20 * from table(表名) where id(主键) not in(select top 10 id from table)
如果要查询第十条到第一百条就是:
select top 90 * from table(表名) where id(主键) not in(select top 10 id from table)
如果要按id降序的话,就要加上order by pId DESC 括号里也要加
select top 20 * from table(表名) where id(主键) not in(select top 10 id from table)
如果要查询第十条到第一百条就是:
select top 90 * from table(表名) where id(主键) not in(select top 10 id from table)
如果要按id降序的话,就要加上order by pId DESC 括号里也要加