展开全部
SqlServer查询操作步骤:
①先根据ID升序 查询前30条记e69da5e887aa62616964757a686964616f31333363373762录信息,再将查询的结果根据ID降序 查询前20条记录。select *
from (select top 20 * from (select top 30 * from 表名 order by ID) t1 order by ID desc) t2
order by ID
②先将查询出前10条记录信息,然后将这10条信息从结果集中剔除掉。select top 10 * from 表名 where id not in (select top 10 id from 表名 order by id asc) order by ID
③先查询出前10条记录最大的ID,然后再查询出>ID的前10条记录信息。select top10 *
from 表名
where ID>(select max(ID) from (select top10 ID from 表名 order by ID) t1)
order by ID
④SqlServer2005后可以根据ROW_NUMBER查询。select * from
(select *, ROW_NUMBER() OVER (order by ID) AS ROWNUM from 表) t
where ROWNUM between 21 and 30