Re: Help in Query Latest -- Urgent

From: <sybrandb_at_yahoo.com>
Date: 31 Jul 2003 02:21:23 -0700
Message-ID: <a1d154f4.0307310121.1a176e7d@posting.google.com>

"Shafeek Khalidh" <itsprobablyme_at_msn.com> wrote in message news:<bgabhf$meiso$1_at_ID-137434.news.uni-berlin.de>...
> Hi all,
>
> Here is a table structure,
> Cource_table
> ============
> ID
> End_Cource_date
> Teacher_id
>
> Test Data...........
> ID --End_Cource_date-----Teacher_id
> ====================================
> 1 ---1/1/2003------------T100
> 2----2/2/2003------------T100
> 3----1/2/2003------------T100
> 4----Null-----------------T100
> 5----2/1/2003------------T101
> 6----3/1/2003------------T101
> 7----4/1/2003------------T101
> 8----2/1/2003------------T101
>
> I want to get the latest two ids corresponding to each teacher.If the date
> is null, Thats the latest date. (mm/dd/yyyy format)
>
> One more thing, I need the results as the following format,
> Teacher_id------End_Cource_date-----Second_End_Cource_date
> ==============================================
> T100------------Null-------------------2/2/2003
> T101------------4/1/2003--------------3/1/2003
>
>
> Please help
> Thanks
> Shafeek Khalidh

Could you please stop posting your homework here? You have now posted in three times in two subsequent days. You could have solved several times yourself, as it has been posted many times in this forum. But apparently you are also too lazy to search Google

Sybrand Bakker
Senior Oracle DBA Received on Thu Jul 31 2003 - 04:21:23 CDT