sql连续天数计算
<!--小程序-我的-学习记录-连续学习天数-->
<select id="studyStatistics2" resultType="java.util.Map">
SELECT uid, max(days) lianxu_days, min(login_day) start_date,max(login_day) end_date
FROM (SELECT uid,
@cont_day :=
(CASE
WHEN (@last_uid
原创
2020-10-30 09:19:10 ·
506 阅读 ·
0 评论