SQL进阶技巧：如何求组内排除当前行的移动平均值

文章预览

点击上方【蓝色】字体   关注我们 01 场景描述 -- 按照 日期，省份，等级 分组 求分数的平均值；但是需要剔除当前行的数据 02 数据准备 create table avgtest as ( select '2024-10-24' as cdate, '广东' as province, '深圳' as city, '2' as level , 200 as score union all select '2024-10-24' as cdate, '广东' as province, '广州' as city, '3' as level , 300 as score union all select '2024-10-24' as cdate, '广东' as province, '湛江' as city, '4' as level , 800 as score union all select '2024-10-24' as cdate, '广东' as province, '茂名' as city, '4' as level , 1000 as score union all select '2024-10-24' as cdate, '广东' as province, '梅州' as city, '5' as level , 1100 as score union all select '2024-10-24' as cdate, '广东' as province, '韶光' as ………………………………