Re: Why using "Group By"

From: stu <smcgouga_at_nospam.co.uk>
Date: Thu, 13 Mar 2003 11:03:37 -0000
Message-ID: <b4pole$o2t$1$8300dec7@news.demon.co.uk>

"oferbu" <junkbu_at_hotmail.com> wrote in message news:b9b409f2.0303130207.42f8ab91_at_posting.google.com...
> Hello All,
>
> This is a theoretical question. Why do I need to add the "Group By" in
> the following SQL:
>
> SELECT
> CUSTOMER_CITY, COUNT(*)
> FROM
> CUSTOMER_TABLE
What happens when you actually want
> SELECT
> CUSTOMER_CITY, COUNT(*)
> FROM
> CUSTOMER_TABLE
do you say dont group by...?

I think it is best to be as explicit as possible.

Cheers
Stu Received on Thu Mar 13 2003 - 05:03:37 CST