Interested to Buy Any Domain ? << Click Here >> for more details...
I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?
- 8 Answers
- 16945 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is field delimiter?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What are string functions in sql?
What is crud stand for?
What is nvl?
What is rownum?
How do I view tables in mysql?
How can we make an if statement within a select statement?
What does pl sql developer do?
How do you create a unique index?
How to pipe multiline string to isql?
Is sql similar to python?
What is left join in sql?
Explain the types of joins in sql?
What does sql stand for?
