SQL sum()

SUM function is used to calculate and return the summation of values in a column of a sql table.

Obviously the column has all the numeric values.For example a column containing age values.

---

SYNTAX :

SUM(column_name)

Table Name 'customers'

id	name	age	city	bill
1	Tom	34	Paris	5300
2	Jhony	51	London	400
3	Ram	64	Delhi	20000.7
4	Simon	23	Portland	32.65

---