[Oracle rank() 함수 쓰는 방법

select a.fi_org_nm chain_fi_org_nm, c.rgst_seq chain_rgst_seq, rank() over (partition by a.fi_org_cd order by a.resident_no) as num,
 c.recp_no, c.cust_name,   substr(b.chae_no,1,6)||'-'|| substr(b.chae_no,7,7) resident_no
from crss_bank_amt a, batch_user.temp_f07_userid  b, crss_debt_cust c
where b.chae_no = a.resident_no
and b.chae_no = c.resident_no;

 

 

rank() over (partition by a.fi_org_cd order by a.resident_no) as num,

===> 금융기관별로 주민번호로 정렬해서 랭킹을 매긴다...

국민은행만 1, 2, 3, 4, 5,

삼성카드만  1, 2, 3, 4, 5