select * from A where rownum < 5 order by A.c
随便取了4条排序,rownum 打乱了 order by
除了 select * from (select * from A order by A.c )where rownum < 5 ;
还有别的方法吗?效率第一;
...全文
544打赏收藏
oracle 排序 rownum
select * from A where rownum < 5 order by A.c 随便取了4条排序,rownum 打乱了 order by 除了 select * from (select * from A order by A.c )where rownum < 5 ; 还有别的方法吗?效率第一;