文章目录 group by注意点partition by group by注意点 GROUP BY必须得配合聚合函数来用如select count(id2) from test1 group by id1 对所有id1相同的行执行sum(id2) 计数(COUNT),求和(SUM),求平均数(AVG)等。 partition by select id1,id2,sum(id2) over (partition by id1) from test1;