Re: Help Need for a Query
From: Bent Stigsen <ngcdo_at_thevoid.dk>
Date: Fri, 25 Jun 2004 13:49:16 +0200
Message-ID: <40dc113f$0$457$edfadb0f_at_dread14.news.tele.dk>
Date: Fri, 25 Jun 2004 13:49:16 +0200
Message-ID: <40dc113f$0$457$edfadb0f_at_dread14.news.tele.dk>
Prabu Krishnan wrote:
[snip]
> I need the Result as the following By a Single SQL Query
>
>
> EID ENAME
> ------ ----------
> 1001 John
> 1004 DO
> 1002 Gokul
> 1005 DO
> 1003 Daniel
> 1006 DO
This should get you started, but you should rewrite it so it used outer joins on subselects of the emp table, because the below sql would be painfully slow.
select
e.eid,
(select case when min(eid)=e.eid then ename else 'DO' end from emp
where ename=e.ename group by ename) ename
from emp e
order by (select min(eid) from emp where ename=e.ename group by ename),
e.eid
/Bent Received on Fri Jun 25 2004 - 13:49:16 CEST