Easy, SQL - MAX()
RunTime : 528 ms
문제
Write a solution to report the latest login for all users in the year 2020. Do not include the users who did not login in 2020.
Return the result table in any order.
The result format is in the following example.
풀이
- 핵심은 가장 빠른 날짜는
MAX()를 사용해서 얻을 수 있다는 것이다.
SELECT user_id, MAX(time_stamp) as last_stamp FROM Logins
WHERE YEAR(time_stamp) = '2020'
GROUP BY 1 
멈춤에 두려움을 느끼는 것