先求出每一个用户记录的下一条登录记录的时间和最早登录时间 SELECT DATE_FORMAT(in_time,'%Y-%m-%d') dt, DATE_FORMAT(out_time,'%Y-%m-%d') out_time, # 退出登录时间,用于判断登录时间是跨天 LEAD(in_time,1) OVER(PARTITION BY uid ORDER BY in_time) pre_record,# 下次登录时间 MIN(in_time) OVER (PARTITION BY uid ORDER BY in_time...