I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?
Answers were Sorted based on User's Feedback
Answer / kavithanedigunta
select deptno,sum(sal) from employee
group by deptno;
Is This Answer Correct ? | 72 Yes | 4 No |
Answer / vikneswaran
SELECT deptno,SUM(sal) FROM emp
GROUP BY deptno
Is This Answer Correct ? | 12 Yes | 2 No |
select department_id,sum(salary) Dept_wise_salary,job_id from employees group by department_id,job_id
/
Output
DEPARTMENT_ID DEPT_WISE_SALARY JOB_ID
------------- ---------------- ----------
110 8300 AC_ACCOUNT
90 34000 AD_VP
50 55700 ST_CLERK
80 243500 SA_REP
110 12000 AC_MGR
50 36400 ST_MAN
80 61000 SA_MAN
50 64300 SH_CLERK
20 13000 MK_MAN
90 24000 AD_PRES
60 28800 IT_PROG
DEPARTMENT_ID DEPT_WISE_SALARY JOB_ID
------------- ---------------- ----------
100 12000 FI_MGR
30 13900 PU_CLERK
100 39600 FI_ACCOUNT
70 10000 PR_REP
7000 SA_REP
10 4400 AD_ASST
20 6000 MK_REP
40 6500 HR_REP
30 11000 PU_MAN
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sudarsan
SELECT
DeptNo AS Department,
Count(DeptNo) AS Dept_Count,
Sum(Salary) AS Salary_DeptWise FROM Employee
GROUP BY DeptNo
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / radheshyam mali
Select sum(salary) from Employee group by deptno
Is This Answer Correct ? | 6 Yes | 10 No |
Answer / lova raju allumalla
instead of deptno the result will give u in department name
select sum(sal),dname from emp e,dept d where
e.deptno=d.deptno group by dname
/
Is This Answer Correct ? | 0 Yes | 4 No |
Answer / madhusudan darshannkar
SELECT COUNT(EID) AS EMPLOYEE,DEPTNON,SUM(SALARY) FROM
EMPLOYEE GROUP BY DEPTNO
Is This Answer Correct ? | 4 Yes | 12 No |
i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.
what is the different between unique+not null & primary key,
Why stored procedures are faster than query?
what is a field in a database ? : Sql dba
What is foreign key and example?
how many triggers are allowed in mysql table? : Sql dba
create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?
Explain raise_application_error.
Why commit is not used in triggers?
What is rename command in sql?
Why use triggers in sql?
How do I view tables in sql developer?