我自己建的一个临时表:
select 'A' as name ,1 as num,2 as dd
union all
select 'A' as name ,2 as num,3 as dd
union all
select 'A' as name ,3 as num,7 as dd
union all
select 'B' as name ,4 as num,1 as dd
union all
select 'B' as name ,6 as num,4 as dd
union all
select 'C' as name ,2 as num,3 as dd
union all
select 'C' as name ,5 as num,5 as dd
union all
select 'C' as name ,8 as num,6 as dd
第一:
sum函数
select *, sum(num) over (partition by name) from
(select 'A' as name ,1 as num,2 as dd
union all
select 'A' as name ,2 as num,3 as dd
union all
select 'A' as name ,3 as num,7 as dd
union all
select 'B' as name ,4 as num,1 as dd
union all
select 'B' as name ,6 as num,4 as dd
union all
select '