创建测试表 1 2 3 4 5 6 7 8 9 10 11 create table t (a varchar(10), b int, c varchar(1)) insert into t values ('张三',1,'Y') insert into t values ('张三',2,'Y') insert into t values ('张三',3,'N') insert into t values ('李四',1,'Y') insert into t values ('王五',1,'Y') insert into t values ('王五',2,'Y') 执行查询 1 2 3 4 select a,MIN(b) b,c from t where a in (select a from t group by a having COUNT(distinct c)>1) group by a,c 结果