select * from(select row_number() over (ORDER BY Id DESC) cyqrownum,t.* from [Table_TY_Member] t ) v where cyqrownum between 11 and 20
select top 10 *from Table_TY_Member where id not in(select top 10 id from Table_TY_Member);--查询显示11-20条记录(10条)本文共 245 字，大约阅读时间需要 1 分钟。
select * from(select row_number() over (ORDER BY Id DESC) cyqrownum,t.* from [Table_TY_Member] t ) v where cyqrownum between 11 and 20
select top 10 *from Table_TY_Member where id not in(select top 10 id from Table_TY_Member);--查询显示11-20条记录(10条)转载地址：http://evkwa.baihongyu.com/