oracle，去重，多条件统计，语句怎么写

Question

查询条件：
CASE WHEN v.calltype='1' THEN COUNT(DISTINCT v.callid) END num,
CASE WHEN v.isworktime='0' THEN COUNT(DISTINCT v.callid) END num1,
CASE WHEN v.isworktime='1' THEN COUNT(DISTINCT v.callid) END num2,
CASE WHEN v.inivrdt IS NULL AND (v.remark='2' OR v.remark='3') THEN COUNT(DISTINCT v.callid) END num1,
CASE WHEN v.inivrdt IS NOT NULL AND v.isworktime IS NOT NULL THEN COUNT(DISTINCT v.callid) END num3,

        这样语句怎么写

Answer 1

建议你分开统计。CASE WHEN后面的条件没有规律，因此要么在java端写代码统计，要么sql分开统计比较好实现。