如何实现 这样的SQL 语句,按条件统计,类似EXCEL SUMIF()
SLECT name, NVL (SUM (name =”A”), 0), NVL (SUM (name =”B”), 0)
WHERE name in(“A”,”B”)
GROUP BY name
SLECT name, NVL (SUM (name =”A”), 0), NVL (SUM (name =”B”), 0)
WHERE name in(“A”,”B”)
GROUP BY name
,nvl(sum(case when name='B' then num else 0 end),0) B
WHERE name in('A','B')
GROUP BY name
谢谢,这样也行?我没用过 case when name='A' then num else 0 endnum是什么东西??