如何从多条会员发贴回贴记录中获取每个会员最后一个动作
2012-1-30 17:56 Monday  

分类: MySQL 评论(40) 浏览(21362)

select uid,username,title_template,title_data,feedid from uc_feeds as a
where feedid in(select max(feedid) from uc_feeds as b where a.uid=b.uid) order by feedid desc limit 10

这样就可以了

+1 16

留下你的看法: