mysql - 如何给出多于一个的having子句

Question

我在状态列中有不同的值，例如已接收、已退回、已清除，并且我想获取每个状态的总行数

select roll_no as roll,sum(pdc.amount) as amount,count(amount) as given,
       stu_profile.name,f_name,scholarship,class_id,batch_id,statuss
from stu_profile
    left join pdc on pdc.roll = stu_profile.roll_no
where 1 and class_id != ''
group by roll

Answer 1

select roll_no as roll,sum(pdc.amount) as amount,count(amount) as given,
   stu_profile.name,f_name,scholarship,class_id,batch_id,statuss
from stu_profile
left join pdc on pdc.roll = stu_profile.roll_no
where 1 and class_id != ''
group by roll
having amount > 0
   and count(amount) = 4

您可以使用和附加多个具有条件