Table Name : Emp

EID ENAME
------ ----------
1001 John
1002 Gokul
1003 Daniel
1004 John
1005 Gokul
1006 Daniel


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

Prabu Krishnan wrote:
[snip]
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

prabukrishna_msc (AT) yahoo (DOT) com (Prabu Krishnan) wrote in message news:<807a409.0406240624.3534481d (AT) posting (DOT) google.com>...
What have you tried?
(You don't really expect us to do all of your homework for you, do you?)