56,681
社区成员
发帖
与我相关
我的任务
分享
select distinct title,author from book group by title;
select a.* from book a right join (
select max(id) id from book group by title) b on b.id = a.id
where a.id is not null
select title,min(author)
from article
group by title