如上图所示的要求: SELECT * FROM A a WHERE NOT EXISTS (SELECT 1 FROM A b WHERE a.A2=b.A2 AND a.A3=b.A3 AND b.A5='X')