【SQL】SQL中if条件的使用 

count(if(a.STS = #{sts}, a.sts, null)) as scssCnt,
sum(if(a.sts = #{sts}, a.amt, 0)) as scssAMt
View Code

 

posted @ 2024-06-24 13:23  CEO雷总  阅读(19)  评论(0)    收藏  举报