LeetCode_Study_Plan/SQL
1890. The Latest Login in 2020 mysql
개발하는루루
2022. 10. 2. 14:58
https://leetcode.com/problems/the-latest-login-in-2020/?envType=study-plan&id=sql-i
The Latest Login in 2020 - LeetCode
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
select user_id, max(time_stamp) as last_stamp from logins where date(time_stamp) between '2020-01-01' and '2020-12-31' group by user_id;