select
empid,workdate,money,
row_number() over(partition by empid,workdate order by money) seqno
from
tab_name;
empid,workdate,money,
row_number() over(partition by empid,workdate order by money) seqno
from
tab_name;
update tbname t set seqno=(select rnum from (
select rowid rid,row_number() over(partition by empid,workdate order by 1) rk
from tt ) tb where tb.rid=t.rowid);
( select count(*) from tbname t2
where t2.empid = t1.empid
and t2.workdate = t1.workdate
and t2.rowid <= t1.rowid)