Re: Help Need for a Query
From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 25 Jun 2004 09:29:47 -0700
Message-ID: <4b5394b2.0406250829.3b33bd1b_at_posting.google.com>
Date: 25 Jun 2004 09:29:47 -0700
Message-ID: <4b5394b2.0406250829.3b33bd1b_at_posting.google.com>
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 - 18:29:47 CEST