It’s dificil ton explain, i want to Sum the 3 last row for every row. An exemple will be better :
<code>ID VALUE1 RESULT I WANT
===================
1 10 10+5+20 = 35
2 5 5+20+4 = 29
3 20 20+4+50 = 74
4 4 4+50+300 = 354
5 50 50+300+10 = 360
6 300 300+10+15 = 325
7 10 NULL
8 15 NULL
</code>
<code>ID VALUE1 RESULT I WANT
===================
1 10 10+5+20 = 35
2 5 5+20+4 = 29
3 20 20+4+50 = 74
4 4 4+50+300 = 354
5 50 50+300+10 = 360
6 300 300+10+15 = 325
7 10 NULL
8 15 NULL
</code>
ID VALUE1 RESULT I WANT
===================
1 10 10+5+20 = 35
2 5 5+20+4 = 29
3 20 20+4+50 = 74
4 4 4+50+300 = 354
5 50 50+300+10 = 360
6 300 300+10+15 = 325
7 10 NULL
8 15 NULL
I use Oracle SQL. Thanks
<code>with dummy as
(
select 10 as value from dual union all
select 5 from dual union all
select 20 from dual union all
select 4 from dual union all
select 50 from dual union all
select 300 from dual union all
select 10 from dual union ALL
select 15 from dual
)
SELECT value, SUM(value) FROM dummy GROUP BY value
</code>
<code>with dummy as
(
select 10 as value from dual union all
select 5 from dual union all
select 20 from dual union all
select 4 from dual union all
select 50 from dual union all
select 300 from dual union all
select 10 from dual union ALL
select 15 from dual
)
SELECT value, SUM(value) FROM dummy GROUP BY value
</code>
with dummy as
(
select 10 as value from dual union all
select 5 from dual union all
select 20 from dual union all
select 4 from dual union all
select 50 from dual union all
select 300 from dual union all
select 10 from dual union ALL
select 15 from dual
)
SELECT value, SUM(value) FROM dummy GROUP BY value
i dont have idea to how to process
New contributor
the_driver is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1