mysql 分组排序

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

简单介绍核心sql查询语句

select
count(0) as totalCount
from
`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 desc
limit ?,?

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

关键是GROUP  BY  的用法