Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help of query

Re: Help of query

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 31 Jul 2003 01:38:32 GMT
Message-ID: <sq_Va.15946$Vt6.8028@rwcrnsc52.ops.asp.att.net>


What is the teacher's name? Which course are you taking this for? Jim
"Shafeek Khalidh" <itsprobablyme_at_msn.com> wrote in message news:bg9qif$mf08v$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.
>
> Please help
> Thanks
> Shafeek Khalidh
>
>
Received on Wed Jul 30 2003 - 20:38:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US