Hi All,
ok, here's the scenario:
Each employee has a type (1,2,3) and I want to select salary for emp's who have type in (1,2) each, so I wrote:

select dept, decode(type, 1, sum(salary*.4)) sal1,
decode(type, 2, sum(salary*.5)) sal2
from emp
where type in (1,2);

but i get 2 rows returned:

dept sal1 sal2
------ ----- -----
101 555
101 666

any help rendered is appreciated...asap please.....
thanx
oh, and if i can get out of it sal1+sal2 at the same time is appreciated!