表a:
id | JuJue | Dataid
1 | 0 | 23
2 | 1 | 23
3 | 1 | 27
4 | 1 | 23
说明:id自增;JuJue是0表示不拒绝,1表示拒绝;dataid 是用户;
要求:查询表a中拒绝次数>1的DataID
结果:
select distinct a1.dataid from a a1 join (select dataid,
count(dataid) as 'count' from a where Jujue = 1 group by dataid) a2
on a1.Dataid = a2.dataid where a2.count > 1