Re: Basic Oracle ?

I do sympathize. Why do they give questions that are open to interpretation. You probably know exactly how to use the Where and Having clause and could happily explain it if asked, but you can only answer a,b,c,d. You feel like sending the question back with an long explanation. But of course it's done on a computer and hitting the thing would only make you feel better for a few moments.

It should be qualified with the word 'after' or 'before' a group caluclation just to make it obvious (IMO). Is that too simple.

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.
>
> Any help would be appreciated.
>
> Eric
> admin_at_t10.net
Received on Tue Mar 30 1999 - 03:31:35 CST