-- 1.聚合函数
select col, stddev(num) as stddev_col
from (
select 'A' as col, '1' as num
union all
select 'A' as col, '2' as num
union all
select 'A' as col, '3' as num
union all
select 'B' as col, '1' as num
union all
select 'B' as col, '2' as num
) as a
group by col
结果:
-- 2.窗口函数
select col, stddev(num) over(partition by col) as stddev_col
from (
select 'A' as col, '1' as num
union all
select 'A' as col, '2' as num
union