示例:
select row_number() over(partition by comp_no order by t.create_date ) orderNumber,t.* from ing_GBMS.Prem_Main_Tab t where t.comp_no='G061101636' order by t.comp_no,T.CNTRL_NO desc
select row_number() over(partition by comp_no order by t.create_date ) orderNumber,t.* from ing_GBMS.Prem_Main_Tab t where t.comp_no='G061101636' order by t.comp_no,T.CNTRL_NO desc