# Write your MySQL query statement below
select distinct author_id as id
from Views
where author_id=viewer_id
order by id asc;
注意:distinct 表示返回相同的直接过滤,相同的只返回一条。
order by中,asc表示升序(默认),desc(降序)
# Write your MySQL query statement below
select distinct author_id as id
from Views
where author_id=viewer_id
order by id asc;
注意:distinct 表示返回相同的直接过滤,相同的只返回一条。
order by中,asc表示升序(默认),desc(降序)