方法）分组

  • 按照user_id升序排序
    SELECT user_id, MAX(date)
FROM login
GROUP BY user_id
ORDER BY user_id;