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

What is sap sql?

960

---

Can we rollback truncate?

985

---

What is the difference between joins?

1021

---

How do I kill a query in postgresql?

1072

---

Why do we need cursors in pl sql?

1059

---

Why do we use procedures in sql?

1058

---

What is difference between function and trigger?

1023

---

What is rowtype?

997

---

What is substitution variable?

1030

---

what happens if null values are involved in expressions? : Sql dba

1027

---

Mention what pl/sql package consists of?

979

---

Where the sql database files are stored?

998

---

What is a string data type in sql?

1021

---

What are different sql data types?

1014

---

What is 19 null in sql?

934

---