Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Why using "Group By"

Why using "Group By"

From: oferbu <junkbu_at_hotmail.com>
Date: 13 Mar 2003 02:07:14 -0800
Message-ID: <b9b409f2.0303130207.42f8ab91@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 - 04:07:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US