Re: SQL*plus please help

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!