728x90
https://leetcode.com/problems/article-views-i/
SELECT
DISTINCT(viewer_id) AS id
FROM Views
WHERE author_id = viewer_id
ORDER BY id ASC;728x90
'IT > 코딩테스트' 카테고리의 다른 글
| [Leetcode] 1581. Customer Who Visited but Did Not Make Any Transactions (0) | 2023.08.30 |
|---|---|
| [Leetcode] 1683. Invalid Tweets (0) | 2023.08.29 |
| [Leetcode] 2356. Number of Unique Subjects Taught by Each Teacher (0) | 2023.08.28 |
| [Leetcode] 941. Valid Mountain Array (0) | 2023.08.28 |
| [Leetcode] 1299. Replace Elements with Greatest Element on Right Side (0) | 2023.08.26 |