oj-sql

题目

1148. 文章浏览 I

思路

1. 先筛选，再去重；

solution

where distinct

select distinct author_id as id
from Views
where author_id=viewer_id
order by id asc
;