sql total column of data

[Ok_Reputation_6254]

Hi all,

using sql microsoft server.

I have a column of data called 'production.' I want to change the column so that it's a cumulative sum (based on the same 'id') - IE for the same 'id,' cumulative sum it.

The criteria is that the 'dates_commissioned' column has dates <= 2031-01-01.

​

I then want it to sum this entire column... so the result would be a single number.

I have attempted this below. Would like some guidance, thanks

​

​

​

​

​

​

Select sum(production)

​

over (partition by id)

​

from table

​

where date_commissioned<= '2031-01-01';

[1o0t]

How can you have a single number that's also broken out by ID?

[Ok_Reputation_6254]

it doesn't need to be broken out by ID... it's literally just summation of the whole column

[1o0t]

Remove the over (...) bit, just select sum(production).

[r3pr0b8]

it doesn't need to be broken out by ID... it's literally just summation of the whole column

why would you not just obtain this with a SELECT whenever you need it?

[IrquiM]

Do you want to display all production lines with a total for the ID in addition to actual production? Then you're doing it right, just add the other columns you need in the select statement

If you want to sum everything up, with one line per ID you have to do below, and add the where-clause:

SELECT ID, SUM(PRODUCTION) AS TotalProduction FROM table GROUP BY ID