select * from (select * , ROW_NUMBER() over (order by id desc) RN from [tb_article] ) TB where RN between 10 and 100 order by id desc
select * from (select * , ROW_NUMBER() over (order by id desc) RN from [tb_article] where s_classid=(select id from tb_article_class where s_name=@classname) ) TB where RN between @bid and @eid order by id desc