--try select * from table where 审核人 not in (select distinct 审核人 from table where 审核<>1)
那这样写就好了...select distinct 审核人 from t where 审核=0 顺便说下 最好把邮箱信息放到另一个表里...
create table t(审核 int,审核人 char(20),number int) insert t select 1,'张三',10 union all select 0,'张三',9 union all select 1,'张三',8 union all select 1,'张三',7 union all select 0,'张三',9 union all select 1,'李四',8 union all select 1,'李四',7 union all select 1,'李四',8 union all select 1,'李四',7 union all select 0,'赵六',9 union all select 1,'赵六',8 union all select 1,'赵六',7 union all select 1,'赵六',8 union all select 1,'赵六',7 select distinct 审核人 from table where 审核人 not in (select distinct 审核人 from table where 审核<>1)------------ 李四
select * from table
where 审核人 not in (select distinct 审核人 from table where 审核<>1)
顺便说下 最好把邮箱信息放到另一个表里...
insert t select 1,'张三',10 union all
select 0,'张三',9 union all
select 1,'张三',8 union all
select 1,'张三',7 union all
select 0,'张三',9 union all
select 1,'李四',8 union all
select 1,'李四',7 union all
select 1,'李四',8 union all
select 1,'李四',7 union all
select 0,'赵六',9 union all
select 1,'赵六',8 union all
select 1,'赵六',7 union all
select 1,'赵六',8 union all
select 1,'赵六',7 select distinct 审核人 from table
where 审核人 not in (select distinct 审核人 from table where 审核<>1)------------
李四