mysql8.0窗口函数
1.求平均值
select name, avg(balance) over(partition by name) as avg from channel;
根据name分组求balance的平均值
2.求总和
select name, sum(balance) over(partition by name) as balanveAvg from channel;
根据name求balance的总和
1.求平均值
select name, avg(balance) over(partition by name) as avg from channel;
根据name分组求balance的平均值
2.求总和
select name, sum(balance) over(partition by name) as balanveAvg from channel;
根据name求balance的总和