INSERT INTO A(姓名,身份证号,住址) SELECT 'A','01','W'
UNION ALL SELECT 'A','01','B'
UNION ALL SELECT 'X','01','A'
UNION ALL SELECT 'C','01','C'
UNION ALL SELECT 'D','01','D'
UNION ALL SELECT 'B','02','E'
UNION ALL SELECT 'B','02','F'
SELECT A1.* FROM A A1 INNER JOIN A A2 ON A1.姓名=A2.姓名 AND A1.身份证号=A2.身份证号 WHERE A1.住址>A2.住址