-
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|