Why using "Group By"
From: oferbu <junkbu_at_hotmail.com>
Date: 13 Mar 2003 02:07:14 -0800
Message-ID: <b9b409f2.0303130207.42f8ab91_at_posting.google.com>
Hello All,
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:
Date: 13 Mar 2003 02:07:14 -0800
Message-ID: <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 Thu Mar 13 2003 - 11:07:14 CET