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

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

Re: Why using "Group By"

From: Tony <andrewst_at_onetel.net.uk>
Date: 13 Mar 2003 09:20:55 -0800
Message-ID: <c0e3f26e.0303130920.742d882f@posting.google.com>


"Damjan S. Vujnovi?" <damjan_at_NO_SPAM.galeb.etf.bg.ac.yu> wrote in message news:<b4prme$fnl$1_at_news.etf.bg.ac.yu>...
> How will you write (using your sintax) something like this:
>
> SELECT
> CUSTOMER_CITY, COUNT(*)
> FROM
> CUSTOMER_TABLE
> GROUP BY
> CUSTOMER_CITY, SOME_OTHER_CUSTOMER_TABLE_ATTRIBUTE
Well, why would you really want to? If I do that and the result is:

CUSTOMER_CITY COUNT(*)

LONDON        12
LONDON        23
LONDON        34
PARIS         17
PARIS         99

This is another case of SQL bags rather than sets complicating queries. Received on Thu Mar 13 2003 - 11:20:55 CST

Original text of this message

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