Re: Why using "Group By"
Date: 16 Mar 2003 22:32:22 -0800
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:
> CUSTOMER_CITY, COUNT(*)
> Isn't it clear that I want to get the number of rows per city, so why
> is it necessary to add:
> GROUP BY
> 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.
> Ofer Buhnik
Received on Mon Mar 17 2003 - 07:32:22 CET