Menu
I have a table Emp which has these rows:
Emp_cd | Val1 | Val2 | Val3 | Total -------+-------+-------+-------+------- 1 | 1.23 | 2.23 | 3.43 | 2 | 23.03 | 12.23 | 2.92 | 3 | 7.23 | 9.05 | 13.43 | 4 | 03.21 | 78.23 | 9.43 | I want to find SUM of Val1, Val2, Val3 and which will show in the Total column.
602
All you need to do is use the multiplication operator (*) between the two multiplicand columns ( price * quantity ) in a simple SELECT query. You can give this result an alias with the AS keyword; in our example, we gave the multiplication column an alias of total_price .
The SQL AGGREGATE SUM() function returns the SUM of all selected column. Applies to all values. Return the SUM of unique values. Expression made up of a single constant, variable, scalar function, or column name.
We can use SUM() function on multiple columns of a table.
Easy:
SELECT Val1, Val2, Val3, (Val1 + Val2 + Val3) as 'Total' FROM Emp or if you just want one row:
SELECT SUM(Val1) as 'Val1', SUM(Val2) as 'Val2', SUM(Val3) as 'Val3', (SUM(Val1) + SUM(Val2) + SUM(Val3)) as 'Total' FROM Emp You must also be aware of null records:
SELECT (ISNULL(Val1,0) + ISNULL(Val2,0) + ISNULL(Val3,0)) as 'Total' FROM Emp Usage of ISNULL:
ISNULL(col_Name, replace value) If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
