1148. Article Views I

내공얌냠 2022. 6. 3. 13:20

Article Views I - 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 distinct a.author_id as id
from Views as a
where a.author_id = a.viewer_id
order by id

best

SELECT AUTHOR_ID AS ID
FROM VIEWS
WHERE AUTHOR_ID=VIEWER_ID
GROUP BY ID
ORDER BY ID;

728x90