secid) AS Count,concat(ROUND(count(distinct secid)/(select count(distinct secid) from wca.bond)*100, 2), '%') as Percentage_with_Roundingfrom wca.bond
g
现在我想添加一个“if”语句,2)否则将100%的值赋值给“PercentagestudentID = stuattend.studid AND Absent = 1) AS ClassAbsent, ROUND ((ClassAbsent/ClassDays)*100, 2) AS PercentageELSEEND
FROM stuattend