count(DISTINCT case when ss.status = 40 then ss.id end) as leave_total
语法:
count(DISTINCT case when 条件 then 去重的字段 end)
也就是对满足条件的字段再次去重。
count 单纯的条件不加去重语法:
count(ss.status = 50 or null) as seats_total
只统计status = 50的
count(DISTINCT case when ss.status = 40 then ss.id end) as leave_total
语法:
count(DISTINCT case when 条件 then 去重的字段 end)
也就是对满足条件的字段再次去重。
count 单纯的条件不加去重语法:
count(ss.status = 50 or null) as seats_total
只统计status = 50的