Db2 Developer-C 11.1

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table cc_table(cc_first6 char(6), cc_last4 char(6), cc_hash char(1));

insert into cc_table values
('111111','1111','1'),
('111111','1111','1'),
('111111','1111','1'),
('222222','2222','2'),
('222222','2222','2'),
('333333','3333','3'),
('333333','3333','4'),
('333333','3333','5');
select
cc_first6,
cc_last4,
min(cc_hash) as min_hash,
max(cc_hash) as max_hash,
count(distinct cc_hash) as TheCount
from cc_table
group by CC_FIRST6,cc_last4
having min(cc_hash) <> max(cc_hash)
order by cc_first6,cc_last4


CC_FIRST6
CC_LAST4
MIN_HASH
MAX_HASH
THECOUNT


333333
3333
3
5
3


with cte as (
	select cc_first6, cc_last4, cc_hash,
		count(*) over(partition by cc_first6, cc_last4) card_count,
		count(*) over(partition by cc_first6, cc_last4, cc_hash) card_hash_count
	from cc_table
)
select cc_first6, cc_last4, cc_hash
from cte
where card_count != card_hash_count


CC_FIRST6
CC_LAST4
CC_HASH


333333
3333
3

333333
3333
4

333333
3333
5