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

1Tom34Paris5300
2Jhony51London 400
3Ram64Delhi20000.7
4Simon23Portland32.65



Online Execute/Compile

Quantitative Aptitude
Reasoning
Programming
Interview