rownum:排序、序列就会乱
select rownum,a.* from (select t.* from table t order by t.stamp) a
select row_number() over (order by t.stamp) rn,t.* from table t
select rownum,a.* from (select t.* from table t order by t.stamp) a
select row_number() over (order by t.stamp) rn,t.* from table t