Re: Basic Oracle ?

From: Uwe Schneider <pi_at_nospam.richard-schneider.de>
Date: Mon, 29 Mar 1999 22:12:04 +0200
Message-ID: <36FFDE94.F9174EB2@nospam.richard-schneider.de>

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:12:04 CST