group by order by 排序 解决方法

group by order by 排序 解决方法

错误

SELECT b.subject,c.message from uchome_blog as b,uchome_comment as c where c.id=b.blogid group by c.id order by c.dateline desc limit 0,15

正确：

SELECT b.subject,c.message from uchome_blog as b,uchome_comment as c where c.id=b.blogid group by c.id order by max(c.dateline) desc limit 0,15