SQL查询选择求和点

皇家联盟

我有 2 张桌子

我想编写 sql 来选择分数 May Month, 2019 year ,trimester 2 这是我选择五月分数的代码

 SELECT
    XD.user_Id, XD.[Name],XD.viTri,XD.sex ,SUM(BD.Point) as pointM
 FROM
    XemDiem XD
 INNER JOIN
    BieuDo BD On BD.user_Id = XD.user_Id
WHERE Month(BD.[DateTime]) = 5 
GROUP BY
    XD.user_Id, XD.[Name],XD.viTri ,XD.sex

结果应该是这样的

米格尔·卡雷拉

请尝试以下操作：

select XD.user_Id, XD.[Name],XD.viTri,XD.sex
sum(case when MONTH(convert(datetime,BD.Date,5)) = 5 and Year(convert(datetime,BD.Date,5)) = 2019 then BD.Point else 0 end) as monthP,
sum(case when MONTH(convert(datetime,BD.Date,5)) >= 4 and MONTH(convert(datetime,BD.Date,5)) <= 6 and Year(convert(datetime,BD.Date,5)) = 2019 then BD.Point else 0 end) as trimesterP
sum(case when MONTH(convert(datetime,BD.Date,5)) = 5 and Year(convert(datetime,BD.Date,5)) = 2019 then BD.Point else 0 end) as yearP
from info
    XemDiem XD
 INNER JOIN
    BieuDo BD On BD.user_Id = XD.user_Id
WHERE Month(BD.[DateTime]) = 5 
GROUP BY
    XD.user_Id, XD.[Name],XD.viTri ,XD.sex

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。