mysql分组 并显示前两条

来源:互联网 发布:mac to do list 编辑:程序博客网 时间:2024/04/27 21:22



select * from app_start_list s

where 2>(select count(*) from app_start_list where title=s.title and id<s.id)
order by title

0 0