prabukrishna_msc_at_yahoo.com (Prabu Krishnan) wrote in message news:<807a409.0406240624.3534481d_at_posting.google.com>...
> 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
What have you tried?
(You don't really expect us to do all of your homework for you, do you?)
Received on Fri Jun 25 2004 - 11:29:47 CDT
