分页查询的SQL语句

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条)