Re: Basic Oracle ?

From: <kishoo_at_my-dejanews.com>
Date: Wed, 31 Mar 1999 19:11:33 GMT
Message-ID: <7dts0t$b1h$1@nnrp1.dejanews.com>

You're right Eric! The 'where' clause is used to restrict rows in a simple query, but the 'having' clause is used to restrict the set of rows that form a group based on the 'group by' parameter. You r sure right!!

In article <Pine.GSO.4.05.9903290943090.2613-100000_at_box.t10.net>, Admin <admin_at_box.t10.net> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 13:11:33 CST