how to sum all the salary in a year ?

navedjobs · #1 (**permalink**) 12-08-11, 04:49

i need to calculate the salary given to all employees in a year

Code:

select sum(emp_total_sal)from emp_salary

how to modify this code to get what i need ?

randirsa · #2 (**permalink**) 12-08-11, 05:12

what is the issue with above code?. and provide the structure of emp_salary table.

sql-programmers · #3 (**permalink**) 12-08-11, 06:03

If you want total salary for a particular year of all employees then

SELECT SUM(EMP_TOTAL_SAL)FROM EMP_SALARY WHERE YEAR(EMP_SALARY_DATE) = 2011

If you want total salary for each year of all employees then

SELECT SUM(EMP_TOTAL_SAL)FROM EMP_SALARY GROUP BY YEAR(EMP_SALARY_DATE)

If you want total salary for a particular year of a employee then

SELECT SUM(EMP_TOTAL_SAL)FROM EMP_SALARY WHERE YEAR(EMP_SALARY_DATE) = 2011 AND EMP_ID = '10'

If you want total salary for each year of all employees then

SELECT SUM(EMP_TOTAL_SAL)FROM EMP_SALARY WHERE EMP_ID = '10'
GROUP BY YEAR(EMP_SALARY_DATE)

navedjobs · #4 (**permalink**) 12-08-11, 06:21

Quote:

Originally Posted by sql-programmers

If you want total salary for a particular year of all employees then

SELECT SUM(EMP_TOTAL_SAL)FROM EMP_SALARY WHERE YEAR(EMP_SALARY_DATE) = 2011

If you want total salary for each year of all employees then

SELECT SUM(EMP_TOTAL_SAL)FROM EMP_SALARY GROUP BY YEAR(EMP_SALARY_DATE)

If you want total salary for a particular year of a employee then

SELECT SUM(EMP_TOTAL_SAL)FROM EMP_SALARY WHERE YEAR(EMP_SALARY_DATE) = 2011 AND EMP_ID = '10'

If you want total salary for each year of all employees then

SELECT SUM(EMP_TOTAL_SAL)FROM EMP_SALARY WHERE EMP_ID = '10'
GROUP BY YEAR(EMP_SALARY_DATE)

thanks a lot man
appreciate .

Internet Services

Web Development

Digital Marketing

Consumer Tech