select rownum as num,s.* from(select * from tt order by tt.dates) s会使得rownum的顺序打乱,产生多余的数据,正确的该法:select rownum as num,s.* from tt order by tt.dates
ORACLE中rownum和order by 的关系
最新推荐文章于 2023-07-19 10:06:45 发布
select rownum as num,s.* from(select * from tt order by tt.dates) s会使得rownum的顺序打乱,产生多余的数据,正确的该法:select rownum as num,s.* from tt order by tt.dates