Re: Merge 2 select statements ?

From: Thomas Kellerer <spam_eater_at_gmx.net>
Date: Thu, 27 Nov 2003 22:39:58 +0100
Message-ID: <bq5qve$epd$1@svr7.m-online.net>

mhk schrieb:

> Thanks but ,
>
> As i said earlier i need to merge two tough separate select statement in
> reality.

Then you should have given the tough one at once :-)

> Please help me in merging this following select Statements
>
>
> select ename, '3' As rate from emp where sal = 950;
>
> other is
>
> select ename, '1' As rate from emp where sal = 11950;
>
>

SELECT ename,

        decode( sal,950,'3',11950,'1','') FROM emp
WHERE sal = 950
OR sal = 11950

or

SELECT ename,

        CASE sal
           WHEN 950 THEN '1'
           WHEN 11950 THEN '2'
           ELSE ''
        END

FROM emp
WHERE sal = 950
OR sal = 11950 Received on Thu Nov 27 2003 - 15:39:58 CST