hive判断一个code对应两个名称sql写法

with  a as (
select code,name from tb_name group by code,name
)
,
b as (
select code ,count(*) cn from a
)
select * from b where cn >1
;