描述: 需要统计同一个表中不同的类型的数量统计然后显示在不同列上。需要显示如图效果
SELECT
picking_user_id userId,
picking_user NAME,
sum( CASE valuation_type WHEN 0 THEN 1 ELSE 0 END ) AS standard_total,
sum( CASE valuation_type WHEN 1 THEN 1 ELSE 0 END ) AS non_standard_total
FROM
t_goods_order_detail
WHERE
picking_datetime >= '2020-08-13'
AND picking_datetime <= '2020-08-15'
GROUP BY
picking_user