select a.inter_no,
row_number() over(partition by b.connid order by a.begin_time) rn
from CALL_CALOG_RECORD a, asr_pac_call_info b
where a.inter_no = b.session_id
row_number() over(partition by b.connid order by a.begin_time) rn
from CALL_CALOG_RECORD a, asr_pac_call_info b
where a.inter_no = b.session_id
and a.inter_ct is null
利用partition排序