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 |
How would you reference column values before and after you have inserted and deleted triggers?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
how to insert the records in particular position
discuss about myisam index statistics collection. : Sql dba
What is meaning of <> in sql?
Is left join inner or outer by default?
Why do we use %rowtype & %type in plsql?
What are primary key and foreign key and how they work?
i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???
3 Answers Scope International,
What are the different dcl commands in sql?
what are the type of locks ? : Sql dba
What types of commands can be executed in sql*plus?