Re: Why using "Group By"

So if I sum all the replies by now, there is no really any need for the extra information added by the clause "Group by YYY, ZZZ" when the SQL already contains an aggregate function, right?

cheers
/ofer

junkbu_at_hotmail.com (oferbu) 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
>
> Isn't it clear that I want to get the number of rows per city, so why
> is it necessary to add:
>
> GROUP BY
> CUSTOMER_CITY
>
> I mean to say that those added lines didn't give more information, and
> any resonable person (or a good sql parser...) could have understand
> what I really want at the first sql.
>
>
> Regards
> Ofer Buhnik
Received on Mon Mar 17 2003 - 00:32:22 CST