我需要编写一个sql脚本来计算每个月初赎回后客户的剩余积分。但是我不太确定SQL查询和SQL脚本之间的区别。我写了两个查询来计算赚取和花费的积分。对于总积分:
select Tbl_member.member_id,sum(points_earned)
from Tbl_member, Tbl_member_participation
where tbl_member_participation.member_id = Tbl_member.member_id
group by Tbl_member.member_id,
和花费的积分:
select Tbl_member.member_id,sum(points_redeemed)
from Tbl_member, Tbl_member_redemption
where tbl_member_redemption.member_id = Tbl_member.member_id
group by Tbl_member.member_id
我想从赚取的积分中减去花费的积分,但是我不知道如何将其组合成一个signle输出sql脚本。以及如何每月运行一次。
试试这个
SELECT Tbl_member.member_id,
Sum(points_earned) - Sum(points_redeemed) Remaining_points
FROM Tbl_member
JOIN Tbl_member_participation
ON tbl_member_participation.member_id = Tbl_member.member_id
JOIN Tbl_member_redemption
ON tbl_member_redemption.member_id = Tbl_member.member_id
GROUP BY Tbl_member.member_id,
Datepart(mm, datecol),
Datepart(yyyy, datecol)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句