sql 得到连续签到天数及总签到天数

最新推荐文章于 2025-05-12 09:53:55 发布

linzhang1rx

最新推荐文章于 2025-05-12 09:53:55 发布

阅读量6.9k

点赞数 2

CC 4.0 BY-SA版权

分类专栏： sql

本文链接：https://blog.youkuaiyun.com/linzhang1rx/article/details/71750355

sql 专栏收录该内容

1 篇文章

订阅专栏

DECLARE @days INT SET @days = 0 DECLARE @curr_day DATETIME --创建day用于储存连续签到日期SET

@curr_day = GETDATE() --curr_day为当前日期

WHILE EXISTS(SELECT null FROM Mall_MemberSign_Log WHERE [MemberId]=11514 AND DATEDIFF(dd,SignTime,@curr_day) = 1) --进行循环判断之前一天是否签到

BEGIN

SET @days = @days + 1

SET @curr_day = DATEADD(dd, -1, @curr_day)

END

if((select 1 from Mall_MemberSign_Log where MemberId=11514 and convert(varchar(10), getdate(), 23)=convert(varchar(10), SignTime, 23)) is not null) --判断今天是否签到了

BEGIN SET @days = @days + 1

END

select @days as ContinuitySignDay ,COUNT(SignTime) as SignCount ,SUM(Integral) as TotalIntegral from Mall_MemberSign_Log where [MemberId]=11514 --得到连续签到天数，总签到次数，签到获得的积分