1 Star 0 Fork 254

隔壁老于 / bean-searcher

forked from Troy / bean-searcher 
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
克隆/下载
TODO.md 801 Bytes
一键复制 编辑 原始数据 按行查看 历史
Troy 提交于 2022-07-07 23:39 . TODO

Next

优化带 groupBy 的统计查询,例如:

select count(*) s_count 
from (
    select avg(score) c_2, sum(score) c_1, course_id c_0 
    from student_course2 
    group by course_id 
    having (sum(score) > 100)
) t_

可优化为:

select count(*) s_count 
from (
    select 1 from student_course2 
    group by course_id 
    having (sum(score) > 100)
) t_

再如:

select count(*) s_count, sum(c_2) s_sum_c_2
from (
    select avg(score) c_2, sum(score) c_1, course_id c_0 
    from student_course2 
    group by course_id 
    having (sum(score) > 100)
) t_

可优化为:

select count(*) s_count, sum(c_2) s_sum_c_2
from (
    select avg(score) c_2 from student_course2 
    group by course_id 
    having (sum(score) > 100)
) t_
Java
1
https://gitee.com/yuzhanfeng/bean-searcher.git
git@gitee.com:yuzhanfeng/bean-searcher.git
yuzhanfeng
bean-searcher
bean-searcher
dev

搜索帮助