Help with SQL Select statement
From: <smagadi_at_yahoo.com>
Date: Tue, 14 Sep 1999 18:38:00 GMT
Message-ID: <7rm4m6$uh0$1_at_nnrp1.deja.com>
Hi,
Date: Tue, 14 Sep 1999 18:38:00 GMT
Message-ID: <7rm4m6$uh0$1_at_nnrp1.deja.com>
Hi,
[Quoted] I have a emp table which has data as follows:
Serial No. Start Stop 1 11-SEP-85 2 12-JAN-86 3 18-FEB-86 4 18-FEB-86 20-Mar-86 5 25-MAY-86 6 11-NOV-86 7 11-NOV-86 12-NOV-86 8 22-MAR-87 9 12-SEP-89
I want to write a SQL query which retrives:
Serial No. Start Stop 1 11-SEP-85 2 12-JAN-86 4 18-FEB-86 20-Mar-86 5 25-MAY-86 7 11-NOV-86 12-NOV-86 8 22-MAR-87 9 12-SEP-89
As shown in the example above if there are two start dates which are same, it should retrive the row with the stop date.
Any help would be appreciated.
Thank you
sashi
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Sep 14 1999 - 20:38:00 CEST