mysql 分组排序

App里有个搜索功能，做了个搜索内容上报并在后台查看的功能，为方便运营在后台查看将相同搜索内容分组排序，以便知道用户的需求。

简单介绍核心sql查询语句

selectcount(0) as totalCountfrom`re_event_search_album` where `search_time` >= ? and `search_time` < ? GROUP BY`content`

查询不重复的总条数，显示在右上角;

select * from ( select `search_time`, `content`, COUNT(`content`) as content_count from `re_event_search_album` group by `content`  order by  `search_time`   desc) a order by a.content_count desc

查询所有不重复的分组降序排列；

select * from (select`content`,`search_time`,count(`content`) as content_count from `re_event_search_album`  where  `search_time` >= ? and `search_time` < ?  group by  `content`) a order by a.content_count desclimit ?,?

查看某天搜索内容 ，按不同分组降序并分页。

关键是GROUP  BY  的用法