The SUM() function returns the Total sum of a numeric column.
Syntax :
SELECT SUM(column_name) FROM table_name
The "Custmast" table
Example :
SELECT SUM(Qty) as Total FROM Custamst
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
|
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
|
No comments:
Post a Comment