vssandilya

• Sep 24th, 2006

 

dear friend,

try this code.

select department_id,job_id,sum(salary) from employees where

department_id in(20,50,80,9) group by rollup(department_id,job_id)

then reply me.

sandilya

adarsh_sp

 Profile Answers by adarsh_sp Questions by adarsh_sp

• Oct 3rd, 2006

 

select department,job,sum(salary) from emp where

department in(20,50,80,9) group by rollup(department,job)

Vijayalakshmi

• Jul 6th, 2007

 

SELECT DISTINCT job,
      SUM(CASE deptno WHEN  20 THEN  sal  END)  "Dept 20",
       SUM(CASE deptno WHEN  50 THEN  sal  END)  "Dept 50",
      SUM(CASE deptno WHEN  80 THEN  sal  END)  "Dept 80",
      SUM(sal)  "Total"
FROM emp
GROUP BY job;

geethika

• Oct 10th, 2007

 

select distinct job,
sum(decode(deptno,20,sal) ) "20"
,sum(decode(deptno,50,sal) )"50"
,sum(decode(deptno,80,sal) ) "80"
,sum(decode(deptno,90,sal) )"90"
,sum(sal) "total"
from emp
group by job;

Pallavi50953

 Profile Answers by Pallavi50953 

• Dec 13th, 2007

 

select * from (select job,sum(decode(deptno,20,sal)) dept20,
                           sum(decode(deptno,50,sal)) dept50,
                           sum(decode(deptno,80,sal)) dept80,
                           sum(decode(deptno,90,sal)) dept90,
                           sum(sal) total_sal
        from emp group by job) order by 1

madhukar.charla

 Profile Answers by madhukar.charla 

• Jan 27th, 2008

 

the date is given in the exceel sheet how do we import in to winrunner plz answer my question

shyamvarmatra

 Profile Answers by shyamvarmatra 

• Aug 8th, 2008

 

select job_id,salary,department_id,avg(salary) "Average Salary"
from employees
where department_id in(20,80,90,50)
group by job_id,salary,department_id
order by job_id

pchandna

 Profile Answers by pchandna 

• Jul 23rd, 2009

 

select job,deptno,salary,

sum(salary) over( partition by deptno,job) dep_sum_sal

from emp

ARAVINDA

• Aug 3rd, 2011

 

Code
SELECT  *


  FROM  (SELECT job,


                SUM(DECODE(deptno,10,sal)) DEPT10,


                SUM(DECODE(deptno,20,sal)) DEPT20,


                SUM(DECODE(deptno,30,sal)) DEPT30,


                SUM(DECODE(deptno,40,sal)) DEPT40


           FROM scott.emp


       GROUP BY job)


ORDER BY 1;


 


SELECT  *


  FROM  (SELECT job,


                SUM(DECODE(deptno,10,sal)) DEPT10,


                SUM(DECODE(deptno,20,sal)) DEPT20,


                SUM(DECODE(deptno,30,sal)) DEPT30,


                SUM(DECODE(deptno,40,sal)) DEPT40


           FROM scott.emp


       GROUP BY job)


ORDER BY 1;


 

Mahesh Bhiosale

• Aug 19th, 2011

 

Hi bro, I had recentely learn about matrix queries. By using following code into oracle 9i or sql server 2005 you can create matrix query to get desired result as per ur wish.

Code
SELECT  *


  FROM  (SELECT job_id,


                SUM(DECODE(department_id,10,salary)) DEPT10,


                SUM(DECODE(department_id,20,salary)) DEPT20,


                SUM(DECODE(department_id,30,salary)) DEPT30,


                SUM(DECODE(department_id,40,salary)) DEPT40


           FROM employees


       GROUP BY job_id)

Neha

• Sep 25th, 2011

 

select job in job, sal in salary, sum(salary) in total_sal
where job=(select job in job where deptno=20 and 50 and 80 and 90)
;

sachin

• Apr 18th, 2012

 

select job,
sum(decode(deptno,10,sal)) deptno10,
sum(decode(deptno,20,sal)) deptno20,
sum(decode(deptno,30,sal)) deptno30,
sum(decode(deptno,40,sal)) deptno40
from emp group by job order by 1;