Software Testing

k2G9Eo9
RdZQRt6

Popular Posts

SUM


The SUM() Function return the Sum value of a numeric column.
The basic syntax is as follows:
SELECT SUM(Column_Name) FROM Table_Name
Syntax For SQL:
SELECT SUM(Salary) FROM Employee
Employee
Emp_idNameSurnameSalaryDept_id
1RajeshKhanna450002
2SnehaGupta550004
3SandeepNehte950001
4KirtiPatil250003
5NileshJadhav450003
6DipeshDas350005
7KailashRane620001
8KavitaDeshpande480003
9SanjayDatt500003
10ShrutiHasan780001

After Execute: 
SUM(Salary)
53800.00

No comments:

Post a Comment