在一张表中过滤出同一张卡号对应多个户名数据

今天突然发现一个貌似相仿的例子，在此记录。

select lxdh,kh,zhkhmc,khrzjhm from table 

where id = 666 and lxdh is not null

and lxdh in

(select lxdh from table where id = 666

and lxdh is not null and khrzjhm is not null

group by lxdh

having count(distinct khrzjhm)>=2)