That's all the records of the table, But we can identify the records using
ID and teachers using Teacher id, Cources may be anything.
"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
news:sq_Va.15946$Vt6.8028_at_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:40:46 CDT
