CASE WHEN 里面怎么加DISTINCT的功能
count(distinct case when photo='1' or photo='2' then id else null end )PHnumber
http://bbs.csdn.net/topics/70508033
oracle聚合函数中如何设置条件
SELECT
FORGNUM,
SUM
(
CASE
WHEN
FSAL200>0
THEN
1
ELSE
0
END
),
SUM
(
CASE
WHEN
FSAL200>0
THEN
FSAL200
ELSE
0
END
),
COUNT
(
CASE
WHEN
FSAL100>0
THEN
1
ELSE
0
END
),
SUM
(
CASE
WHEN
FSAL100>0
THEN
FSAL200
ELSE
0
END
),
COUNT
(
CASE
WHEN
FSAL308>0
THEN
1
ELSE
0
END
),
SUM
(
CASE
WHEN
FSAL308>0
THEN
FSAL200
ELSE
0
END
)
FROM
CMPDATA
GROUP
BY
FORGNUM
;
http://bbs.csdn.net/topics/380205874