select t2.* from ( select rownum rn,t.* from qiutubiao t1 where rownum <= 20 order by bianhao desc )t2 where rn >= 11;
有什么问题? 你用ASC是正序排 要倒序排,应该用DESC order by bianhao desc
哦,你是对的。 这个是通过改变哪个值可以获得不同页数的数据呢?select t2.* from ( select rownum rn,t.* from qiutubiao t1 where rownum <= 20 order by bianhao desc )t2 where rn >= 11;粗体字控制
select t2.* from ( select rownum as rn,t1.* from qiutubiao t1 order by bianhao desc ) t2 where rn between 11 and 20
select rownum rn,t.* from qiutubiao t1
where rownum <= 20
order by bianhao desc
)t2 where rn >= 11;
你用ASC是正序排
要倒序排,应该用DESC
order by bianhao desc
这个是通过改变哪个值可以获得不同页数的数据呢?select t2.* from (
select rownum rn,t.* from qiutubiao t1
where rownum <= 20
order by bianhao desc
)t2 where rn >= 11;粗体字控制
select rownum as rn,t1.* from qiutubiao t1
order by bianhao desc ) t2 where rn between 11 and 20