sql语法 select a.* from 表名 as a inner join 表名 as b on a.[姓名]=b.[姓名] and a.[身份证号]<>b.[身份证号] 转载于:https://www.cnblogs.com/wangchengb/p/10075746.html