SQL查询语句,查找出一些

2025-03-23 07:17:54
推荐回答(1个)
回答(1):

select sum(case when state<2 then 1 else 0 end) as 电话费
from vf_departcost where deleted=0
and Costkind not like ('%水费%','%修理费%','%快递费%','%人工费%','%电话费%')