Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Basic Oracle ?
No interpretation problems here. The question says "group calculation"....
only "having" applies directly to group calculation. "where" is at the
select level, "order by" is applied after the group by and "into", well
"into" is really not related to group calculation.
Regards,
Marc Mazerolle
Uwe Schneider wrote:
> Hi Admin,
>
> Admin wrote:
> >
> > I am going through some sample test for the DBA exam and
> > I came across the following question:
> >
> > Which clause would you use to exclude rows from a group calculation?
> >
> > a. where
> > b. having
> > c. order by
> > d. into
> >
> > I chose b because it said group calculation.
> > I know that the where condition excludes rows from
> > a select but I assumed that having excludes rows even
> > further after the group by.
>
> this is a matter of intepretation:
> If you want to exclude rows that should not go into a group calculation,
> you take WHERE. If you need to exclude rows from the GROUP BY result,
> HAVING is right of course.
>
> Uwe
> --
> Uwe Schneider | Telefon +49 7251 / 82587
> Karlsdorfer Str. 31 | Mail pi_at_richard-schneider.de
> DE-76646 Bruchsal |
> Linux - OS al dente!
Received on Mon Mar 29 1999 - 14:25:21 CST