group by 的作用 http://www.w3school.com.cn/sql/sql_groupby.asp 这里写的很清楚了!
那么排序呢? mysql官方没有给出个明确答复,这里从网上搜索到 通过子查询的方法,当然还有自连接的(这个比较好,但是没有找到),
SELECT * FROM (SELECT * FROM posts ORDER BY dateline DESC) AS NEW GROUP BY tid ORDER BY dateline DESC LIMIT 10
select id sid,names sname,imglogo,sort from (select * from shops where tid=8 order by sort desc ) as new group by sname order by sort desc
其实就是 子查询得到一个新表,再对其进行group by。