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

Differentiate between sga and pga.

676

---

Can we create index on primary key?

524

---

What is an exception in pl/sql?

544

---

What does pl sql stand for?

659

---

What is an oracle stored procedure?

595

---

---

What is scalar function in sql?

536

---

what is a tablespace? : Sql dba

564

---

How many types of tables are there?

509

---

What is case function?

603

---

how many ways we can we find the current date using mysql? : Sql dba

620

---

Explain locks? : Transact sql

575

---

What are stored procedures used for?

537

---

What is sql scripting?

563

---

What is fmtonly in sql?

534

---

How does postgresql compare to "nosql"?

583

---