group by 的全部含义就是其根据某一字段进行分组的动作;
- group by 某一字段,实现对该字段的去重;
count + group by
count(id) + group by id:就是分组统计每一个 id 出现的次数;
group by + limit
此时 limit 执行的动作就是按组跳跃,如,查询工资第二高;
select * from Employee group by salary order by salary desc limit 1, 1;
group by 的全部含义就是其根据某一字段进行分组的动作;
count(id) + group by id:就是分组统计每一个 id 出现的次数;
此时 limit 执行的动作就是按组跳跃,如,查询工资第二高;
select * from Employee group by salary order by salary desc limit 1, 1;