-
1890. The Latest Login in 2020 mysqlLeetCode_Study_Plan/SQL 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;'LeetCode_Study_Plan > SQL' 카테고리의 다른 글
1407. Top Travellers mysql (0) 2022.10.03 1741. Find Total Time Spent by Each Employee mysql (0) 2022.10.02 511. Game Play Analysis I mysql (0) 2022.10.02 586. Customer Placing the Largest Number of Orders mysql (0) 2022.10.02 1729. Find Followers Count mysql (0) 2022.10.02