Translate to Tamil

Earn Money


Best Offers

Amazon Best Offers

Offers

Best Online Offers

Amazon Offers

Earn Money Short URL

Sunday, 25 December 2011

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

 Share This Post


No comments:
Write comments

Contact form

Name

Email *

Message *

Infolinks

© 2014