Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
this is the data which i have
name | no. |
abc | 45 |
ddd | 130.5 |
eee | 22 |
rrr | 12 |
ttt | 9 |
yyy | 2.4 |
bbb | 1 |
i need output (sum of no.)
name | no. | output |
abc | 45 | 221.9 |
ddd | 130.5 | 221.9 |
eee | 22 | 221.9 |
rrr | 12 | 221.9 |
ttt | 9 | 221.9 |
yyy | 2.4 | 221.9 |
bbb | 1 | 221.9 |
i want to achieve this in script
regards
Hi kulwant,
Say you have the table:
Data:
Load
name,
no.
From [Whatever];
join (Data)
Load
sum(no.) as Sumation
resident Data;
That will put the total sum at every row of your data.
Felipe.
Hi kulwant,
Say you have the table:
Data:
Load
name,
no.
From [Whatever];
join (Data)
Load
sum(no.) as Sumation
resident Data;
That will put the total sum at every row of your data.
Felipe.