mysql case 函数使用demo

最新推荐文章于 2024-11-26 14:14:29 发布

你走开``

最新推荐文章于 2024-11-26 14:14:29 发布

阅读量310

点赞数

CC 4.0 BY-SA版权

文章标签： mysql

本文链接：https://blog.youkuaiyun.com/qq_34531925/article/details/73548111

本文提供了一个SQL查询案例，展示了如何从采购申请表中按接收人分组统计多项指标，包括总单据数量、申请金额汇总、已购资产计数及价格等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT
purchase.id,
purchase.purchase_count,
purchase.unit_price,
purchase.asset_total_price,
purchase.purpose,
purchase.asset_status,
purchase.receive_person_id,
purchase.remarks,
purchase.del_flag,
purchase.org_id,
COUNT(1) AS countBill,
SUM(purchase.asset_total_price) AS applyPrice,
COUNT(
CASE WHEN purchase.asset_status = ‘2’ THEN 1 ELSE NULL END ) AS isBuyCount,
COUNT(
CASE WHEN purchase.asset_status = ‘3’ THEN 1 ELSE NULL END ) AS uselessBill,
SUM(
CASE WHEN purchase.asset_status = ‘2’ THEN purchase.asset_total_price ELSE 0 END ) AS isBuyPrice
FROM
bus_purchase_apply AS purchase
GROUP BY
purchase.receive_person_id
HAVING
purchase.del_flag = ‘0’
AND purchase.org_id = ‘1’