SELECT user_id, date, lead(date) OVER (PARTITION BY user_id ORDER BY date) as nextdate FROM questions_pass_record ORDER BY user_id 就行了, 不需要ifnull也能过
点赞

相关推荐

牛客网
牛客企业服务