又要去重，又要计数怎么办？

[我不是稻草人]

SELECT
oq_pick_user,
count(oq_id) AS pick_sku_num,
count(DISTINCT oq_order_id) AS pick_order_num,
SUM(CASE WHEN o_outstock_time>0 THEN od_num ELSE 0 END) as chuku_sku_num,
SUM(CASE WHEN o_outstock_time>0 THEN od_num ELSE 0 END) as chuku_sku_num,//这里要以o_id去重。又要o_outstock_time>0 这里怎么写------------------
FROM
v2_order_qrcode
LEFT JOIN v2_order_detail ON od_o_id = oq_order_id and od_sku=oq_sku
LEFT JOIN v2_order ON o_id = oq_order_id
WHERE
oq_order_id=4032125 and o_is_valid=1
group by oq_pick_user

[rick-he]

你是在一个v2_order_qrcode表上select不可以直接在条件里去重？

[LongRui888]

你的意思是 要以 o_id来去重后 sum 这个字段od_num 的值吗？

[LongRui888]

SUM(CASE WHEN o_outstock_time>0 THEN od_num ELSE 0 END) as chuku_sku_num,//这里要以o_id去重。又要o_outstock_time>0 这里怎么写------------------ 这里你是要计算什么？ 是这个意思吗： count(distinct CASE WHEN o_outstock_time>0 THEN o_id ELSE null END) as yyy

[我不是稻草人]

这是我想要的