摘要： select A.part,A.avgvalue,A.sumvalue from (select t.*,sum(sal) over(partition by t.part) as sumvalue,avg(sal) over(partition by t.part) as avgvalue from ATEST t)A group by (part,avgvalue) 发现原来这个有点麻烦，下面... 阅读全文