author, id ,title
a 1 title1
a 2 title2
a 3 title3
b 4 title4
c 5 title5
我现在要一个结果就是,查找id最小的author不能重复的以id升序的前3名的怎么写
如果您是
select distinct author,id,title from table order by id asc limit 3
select * from table group by author order by id asc limit 3
这两种结果就不要贴了,这两个结果都不对
author, id ,title
a 1 title1
b 4 title4
c 5 title5
正确结果应该是这个 |