<div>
try this:<br />
<br />
select job, sum(decode(dept,10,sal,0))<wbr /> as dept10,<br />
&nbsp;sum(decode(dept,20,sal,0))<wbr /> as dept20,<br />
sum(decode(dept,30,sal,0))<wbr /> as dept 30<br />
from emp<br />
group by job
</div>


try this:

select job, sum(decode(dept,10,sal,0)) as dept10,
 sum(decode(dept,20,sal,0)) as dept20,
sum(decode(dept,30,sal,0)) as dept 30
from emp
group by job

<div>
Yes!<br />
Thank You<br />
I appreciate this very much.
</div>


Yes!
Thank You
I appreciate this very much.

<div>
<div class="content wysiwyg-content">
I am trying to get this result from oracle 9i:<br />
<br />
Job &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dept10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Dept20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Dept30 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Total<br />
ANALYST &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6000<br />
CLERK &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1300 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1900 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 950 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4150<br />
MANAGER &nbsp; &nbsp; &nbsp; &nbsp;2450 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2975 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2850 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8275<br />
PRESIDENT &nbsp; &nbsp; &nbsp;5000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5000<br />
&nbsp; <br />
I saw an example using nested decodes that looked someting like this, but I can't seem to put it together. Thanks in advance for looking. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
</div>
</div>


I am trying to get this result from oracle 9i:

Job               Dept10               Dept20          Dept30           Total
ANALYST                                8000                                  6000
CLERK             1300                 1900                 950           4150
MANAGER        2450                 2975                2850          8275
PRESIDENT      5000                                                         5000
  
I saw an example using nested decodes that looked someting like this, but I can't seem to put it together. Thanks in advance for looking.                                                        

Nested decode

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.