要知道group by和order by的用法
group by是按照某一类分组
order by 一般是排序
两者可以共存,几乎缺一不可
例题:
- 按省分类汇总(把sql语句补上)
Select province,count(province)
from log
group by province ;
2.按pageId分类汇总,按汇总量降序排列(把sql语句补充上)
Select pageId,count(pageId) as ct
from log
Group by pageId
order by ct desc;