2,497
社区成员
发帖
与我相关
我的任务
分享
SELECT ORDERNO,
SUM(CASE FLAG WHEN 1 THEN 1 ELSE 0 END) FLAG1,
SUM(CASE FLAG WHEN 2 THEN 1 ELSE 0 END) FLAG2,
SUM(CASE FLAG WHEN 3 THEN 1 ELSE 0 END) FLAG3,
COUNT(1) FLAGALL
FROM MYTABLE
GROUP BY ORDERNO
select OrderNo,
Sum(iif(Flag=1,1,0)) as Flag1,
Sum(iif(Flag=2,1,0)) as Flag2,
Sum(iif(Flag=3,1,0)) as Flag3,
Count(1) as FlagAll
from t
group by OrderNo