select
zyxx.zydm,zyxx.nj,zyxx.jxjhh,row_number() over (partition by zyxx.zydm order by zyxx.jxjhh)
from jwxt.jy_zyxx zyxx
select
zyxx.zydm,zyxx.nj,zyxx.jxjhh,row_number() over (partition by zyxx.zydm order by zyxx.jxjhh)
from jwxt.jy_zyxx zyxx