SQL Sum()

The SUM() function returns the Total sum of a numeric column.

Syntax :

SELECT SUM(column_name) FROM table_name


The "Custmast" table

custcode	custname	city	qty	rate
1	Siva	Srivilliputtur	50	70
2	Bala	Sivakasi	30	56
3	Kanna	Madurai	100	200
4	Vijay	Chennai	30	30
5	Kodee	Sandnes	60	80
5	Kodee	Srivilliputtur	60	30

  


Example :


SELECT SUM(Qty) as Total  FROM Custamst

Total

330