数据记录查询起止卡号和数量

主要以数据输出ID为关键字进行关联进行表内连接得到结果：

表：

select x.*, y.card_base_id, y.card_base_name from (select aa.*, stuff(bb.bank_cardno_YAD076,7,4,'****') + '/' + bb.sb_cardno_YAC005 as end_no from(select a.*, stuff(b.bank_cardno_YAD076,7,4,'****') + '/' + b.sb_cardno_YAC005 as beg_no from(select src_file_name, data_date, ncx_file_name, bank_code_YAD050,       min(ncx_out_id) beg_id, max(ncx_out_id) end_id, count(*) numfrom tab_shebao_info group by src_file_name,data_date,ncx_file_name,bank_code_YAD050) aleft join tab_shebao_info b on a.ncx_file_name = b.ncx_file_name   and a.beg_id=b.ncx_out_id) aa    left join tab_shebao_info bb on aa.ncx_file_name = bb.ncx_file_name   and aa.end_id=bb.ncx_out_id) xleft join tab_bank_type y on x.bank_code_YAD050 = y.bank_code

结果：