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_at_news.demon.co.uk>
Date: Thu, 13 Mar 2003 11:03:37 -0000
Message-ID: <b4pole$o2t$1$8300dec7_at_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 - 12:03:37 CET