条件分支SQL语句<一> Case When

最新推荐文章于 2025-06-18 18:05:39 发布

weixin_33858336

最新推荐文章于 2025-06-18 18:05:39 发布

阅读量376

点赞数

文章标签： php

本文介绍了一个具体的SQL查询案例，展示了如何使用CASE WHEN语句来针对不同的类别ID进行金额的汇总计算，包括收入、支出、投注金额、返利金额、赢取金额及盈亏情况，并关联用户表获取用户详细信息。

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

SELECT

SUM(CASE WHEN dbo.CP_Withdrawal.CateId=5 THEN dbo.CP_Withdrawal.Moneyoperate ELSE 0 END ) AS MoneyIn,

SUM(CASE WHEN dbo.CP_Withdrawal.CateId=6 THEN dbo.CP_Withdrawal.Moneyoperate ELSE 0 END ) AS MoneyOut,

SUM(CASE WHEN dbo.CP_Withdrawal.CateId=1 THEN dbo.CP_Withdrawal.Moneyoperate ELSE 0 END ) AS BetMoney,

SUM(CASE WHEN dbo.CP_Withdrawal.CateId=4 THEN dbo.CP_Withdrawal.Moneyoperate ELSE 0 END ) AS PctMoney,

SUM(CASE WHEN dbo.CP_Withdrawal.CateId=3 THEN dbo.CP_Withdrawal.Moneyoperate ELSE 0 END ) AS WinMoney,

(SUM(CASE WHEN dbo.CP_Withdrawal.CateId=3 THEN dbo.CP_Withdrawal.Moneyoperate ELSE 0 END )+SUM(CASE WHEN dbo.CP_Withdrawal.CateId=4 THEN dbo.CP_Withdrawal.Moneyoperate ELSE 0 END )-SUM(CASE WHEN dbo.CP_Withdrawal.CateId=1 THEN dbo.CP_Withdrawal.Moneyoperate ELSE 0 END )) AS ProfitLoss,

dbo.CP_Users.Id AS UID,

dbo.CP_Users.Username AS UserID,

dbo.CP_Users.Role AS RoleName

 

 FROM dbo.CP_Users LEFT JOIN dbo.CP_Withdrawal ON dbo.CP_Users.Id=dbo.CP_Withdrawal.Uid

 WHERE dbo.CP_Users.Id={0}   AND dbo.CP_Withdrawal.Time BETWEEN '{1}'