Published on

Leetcode - 1890. The Latest Login in 2020

Authors
  • avatar
    Name
    Indo Yoon
    Twitter
Table of Contents

문제

[Loading...

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

](https://leetcode.com/problems/the-latest-login-in-2020/)

정답

SELECT user_id, MAX(time_stamp) AS last_stamp
FROM Logins
WHERE time_stamp >= '2020-01-01'  AND time_stamp < '2021-01-01'
GROUP BY user_id