请教一段SQL语句,要实现的目的:查找身份证号(SFZH)值一样,但姓名(Name)不一样的记录
select * from table where sfzh in (select sfzh from table group by sfzh having count(sfzh)>1
这只是找出身份证号一样的记录,但还想找出姓名不一样的记录,请问SQL语句怎么实现?
...全文
346打赏收藏
ACCESS下一个SQL语句
请教一段SQL语句,要实现的目的:查找身份证号(SFZH)值一样,但姓名(Name)不一样的记录 select * from table where sfzh in (select sfzh from table group by sfzh having count(sfzh)>1 这只是找出身份证号一样的记录,但还想找出姓名不一样的记录,请问SQL语句怎么实现?