select case when lh_lb='一组' and "date"=convert(varchar(10),getdate() - 1,120) then sum(lh_fq) end, case when lh_lb='一组' and "date"=convert(varchar(10),getdate() - 1,120) then sum(lh_ss) end from tb提供一个思路吧
SELECT lh_lb, SUM(lh_fq), SUM(lh_ss) FROM LH_ZT WHERE "date"=convert(varchar(10),getdate() - 1,120) AND lh_lb IN ('一组' , '二组', ...) GROUP BY lh_lb;
case when lh_lb='一组' and "date"=convert(varchar(10),getdate() - 1,120) then sum(lh_ss) end
from tb提供一个思路吧
SUM(lh_fq),
SUM(lh_ss)
FROM LH_ZT
WHERE "date"=convert(varchar(10),getdate() - 1,120)
AND lh_lb IN ('一组' , '二组', ...)
GROUP BY lh_lb;