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:46:47 GMT
Message-ID: <by_Va.15963$Vt6.8117@rwcrnsc52.ops.asp.att.net>


No, I mean for what class is this homework for? What is the professor's name and email address for this assignment? Jim
"Shafeek Khalidh" <itsprobablyme_at_msn.com> wrote in message news:bg9s31$md07q$1_at_ID-137434.news.uni-berlin.de...
> 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:46:47 CDT

Original text of this message

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