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 a file delimiter?

1164

---

What is an exception in PL/SQL? What are the two types of exceptions?

1401

---

Why indexing is needed?

1046

---

What does closing a cursor do?

1375

---

how can we know the count/number of elements of an array? : Sql dba

1109

---

What is sql entity?

1175

---

How do you add a column to a table?

1105

---

How to get list of all tables from a database?

1212

---

discuss about myisam index statistics collection. : Sql dba

1005

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1273

---

Are stored procedures faster than dynamic sql?

1106

---

What happens when a trigger is associated to a view?

973

---

What is trigger types of trigger?

1144

---

What is oracle and pl sql?

1159

---

What is the difference between view and stored procedure?

1003

---