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条)
2023-10-13 15:50:22
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条)