Re: SQL*plus please help

Oops, sorry Daniel, didn't mean to post pretty much exactly what you posted (and not even as detailed as yours I see.. anyways, I accessed it from Google at work - you know how frequently that gets updated!).

Cheers,

Bricklen

Daniel Morgan wrote:

<snipped>

>
> You are, in a SQL context, misusing the word GROUP ... grouping has an entirely
> different meaning and could lead to confusion when asking question. Grouping
> refers to aggregations with operators like MAX, SUM, and COUNT. What you are
> trying to do is strictly a sorting that is done by the ORDER BY clause.
>
> Here's the solution if I understand the question:
>
> SELECT s.school_name, c.child_name, c.dob
> FROM school s., child c
> WHERE c.school_no = sl.school_no
> AND c.dob <= TO_DATE('01-FEB-93')
> ORDER BY school.school_name, child.dob;
>
> I also took the liberty of aliasing the tables in your FROM clause with single
> letters to cut down on the amount of typing and make it easier to read as well
> as correcting your use of a date in the WHERE clause. You 'can' not use TO_DATE
> but it is highly inadvisable as Oracle does not guarantee you will get the
> correct result.
>
> Daniel Morgan
Received on Fri Jun 14 2002 - 21:14:20 CDT