How to sum data of two different columns in SQL

Question

How can I update sum of data from different columns from 1 table to a different column in the same table?

Below is the example:

Name     Jan_Sales Feb_Sales March_Sales  Total_Sales
Cathey   345         450      530            ?
Susan    456         280      430            ?
Jason    346         590      567            ?
Chris    478         344      345            ?

I want to update column Total_Sales by summing Jan, Feb, Mar sales.. For e.g 1325(345+450+530) in total_sales for Cathey.

shree.pat18 · Accepted Answer · 2014-05-06 12:37:05Z

1

Try this:

update yourtable
set total_sales = jan_sales + feb_sales + march_sales

answered May 6, 2014 at 12:37

shree.pat18

21.8k3 gold badges45 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anthony Raymond · Accepted Answer · 2014-05-06 12:41:55Z

1

This may work :

UPDATE
    table_name 
SET 
    Total_Sales = Jan_Sales + Feb_Sales + March_Sales
WHERE 1 = 1;

where 1=1 is to prevent mysql to warn that you are performing an UPDATE without WHERE clause

answered May 6, 2014 at 12:41

Anthony Raymond

7,8626 gold badges47 silver badges63 bronze badges

Collectives™ on Stack Overflow

How to sum data of two different columns in SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related