题解 | 牛客每个人最近的登录日期(一)
牛客每个人最近的登录日期(一)
https://www.nowcoder.com/practice/ca274ebe6eac40ab9c33ced3f2223bb2
select
user_id,
max(date) as id
from
login
group by
user_id
order by
user_id asc
牛客每个人最近的登录日期(一)
https://www.nowcoder.com/practice/ca274ebe6eac40ab9c33ced3f2223bb2
select
user_id,
max(date) as id
from
login
group by
user_id
order by
user_id asc
相关推荐