I have a Employee table with columns ename,eid,salary,deptno. How to retrieve

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?

Question Posted / suma

8 Answers
14311 Views
L&T, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for ..

Answer / kavithanedigunta

select deptno,sum(sal) from employee
group by deptno;

Is This Answer Correct ?

72 Yes

4 No

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for ..

Answer / vikneswaran

SELECT deptno,SUM(sal) FROM emp
GROUP BY deptno

Is This Answer Correct ?

12 Yes

2 No

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for ..

Answer / rs

its right first one

Is This Answer Correct ?

9 Yes

3 No

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for ..

Answer / abhishekjaiswal

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

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for ..

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

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for ..

Answer / radheshyam mali

Select sum(salary) from Employee group by deptno

Is This Answer Correct ?

6 Yes

10 No

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for ..

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

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for ..

Answer / madhusudan darshannkar

SELECT COUNT(EID) AS EMPLOYEE,DEPTNON,SUM(SALARY) FROM
EMPLOYEE GROUP BY DEPTNO

Is This Answer Correct ?

4 Yes

12 No

Post New Answer