Thnaks for that, it seems to working ok now.
"Imprecise" <f_puhan_at_precise.com> wrote in message
news:f_puhan-8E5625.08003214062002_at_vienna7.his.com...
> In article <UykO8.28234$sC4.3582481_at_news6-win.server.ntlworld.com>,
> "Messiah" <asmithster_at_hotmail.com> wrote:
>
> > HI
> >
> > I am using oracle 8 with sql plus to return a query which will have the
> > column headers school_name,child_name and dob.
> > What I need to know is how to get the school_name grouped and the dob in
> > order for the childs in that school.
> > It's a order by within a group, below is my attempt so far:
> >
> > SELECT school.school_name,child.child_name,child.dob
> > 2 FROM school,child
> > 3 WHERE child.school_no = school.school_no and child.dob <=
'01-feb-93'
> > 4 ORDER BY school.school_name;
> >
> >
> > This will get the school_name in order and together but the DOB in not
in
> > order.
> >
> > Any help recieved with great apprechation
>
> If I understand your question correctly, all you need to do is add
>
> child.dob
>
> to the ORDER BY clause:
>
> ORDER BY school.school_name, child.dob;
>
> --
> The underscore character does not belong in my address. You know the
drill...
> ***
> Anyone sufficiently smart enough to configure and use USEnet for research
should
> be smart enough to Read The Freakin' Documentation!
Received on Sat Jun 15 2002 - 00:59:15 CDT
