Help Need for a Query
From: Prabu Krishnan <prabukrishna_msc_at_yahoo.com>
Date: 24 Jun 2004 07:24:39 -0700
Message-ID: <807a409.0406240624.3534481d_at_posting.google.com>
Table Name : Emp
Date: 24 Jun 2004 07:24:39 -0700
Message-ID: <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
1006 DO
Received on Thu Jun 24 2004 - 16:24:39 CEST
------ ----------
1001 John
1004 DO
1002 Gokul
1005 DO
1003 Daniel