没对表做过主外键 索引select * from sdata order by spid desc
单独排序的话是没问题的 但是加到分页sql里查出来就是不规则的 以下是sql语句
select * from (select * from sdata order by spid desc) where rownum <= '10'
minus
select * from (select * from sdata order by spid desc) where rownum <= '5';
求高手帮忙给分析下 为什么不排序 做好是能给出解决方法
单独排序的话是没问题的 但是加到分页sql里查出来就是不规则的 以下是sql语句
select * from (select * from sdata order by spid desc) where rownum <= '10'
minus
select * from (select * from sdata order by spid desc) where rownum <= '5';
求高手帮忙给分析下 为什么不排序 做好是能给出解决方法
(
select rownum rn,* from sdata order by spid desc) where rownum <= '10'
)t where rn>=5;
(
select rownum rn,* from sdata order by spid desc) where rownum <= 10
)t where rn>=5;