I have a Employee table with columns
ename,eid,salary,deptno. How to retrieve sum of salary for
each deptno?
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 the difference between a primary key and a clustered index?
What is the difference between left outer join and left join?
What is difference between function and trigger?
how to fetch common records from two tables? : Sql dba
what is the difference between delete and truncate statement in sql? : Sql dba
How to pipe multiline string to isql?
how many ways to get the current time? : Sql dba
What is full form of rtm?
How do I truncate a word?
Explain the rollback statement?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
what is the difference between char_length and length? : Sql dba
What is the best partition size for windows 10?
What is input buffer in sql*plus?
What is java sql package?