[LeetCode] 1148. Article Views I (easy, SQL)

https://leetcode.com/problems/article-views-i/submissions/1140600137/?envType=study-plan-v2&envId=top-sql-50

LeetCode - The World's Leading Online Programming Learning Platform

전체 코드

SELECT DISTINCT(viewer_id) as id
FROM Views
WHERE author_id = viewer_id
ORDER BY id

 

DISTINCT를 쓰면 중복이 제거된다!