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

主要以数据输出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(*) num
			from tab_shebao_info 
			group by src_file_name,data_date,ncx_file_name,bank_code_YAD050
		) a
		left 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
) x
left join tab_bank_type y 
on x.bank_code_YAD050 = y.bank_code

结果：