mysql 中group by分组查询最新记录
mysql5.5
select DISTINCT t.uid from (
select * from table_name order by create_time desc
) as t
group by t.uid;mysql5.7select DISTINCT t.uid from (
select * from table_name order by create_time desc limit 100000
) as t
group by t.uid;比如说查询文章表中所有用户发表文章的数量及最新的一篇文章select DISTINCT t.uid,count(*) as num,t.id,t.title,t.atime from (select * from bfw_article order by atime desc) as t group by t.uid
{{collectdata}}
网友评论0