Re: Why using "Group By"
From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Thu, 13 Mar 2003 09:32:14 -0800
Message-ID: <dm3ca.8$wV5.57_at_news.oracle.com>
Date: Thu, 13 Mar 2003 09:32:14 -0800
Message-ID: <dm3ca.8$wV5.57_at_news.oracle.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
select CUSTOMER_CITY, CNT from (
SELECT
CUSTOMER_CITY,
SOME_OTHER_CUSTOMER_TABLE_ATTRIBUTE,
COUNT(*) as CNT
FROM
CUSTOMER_TABLE
- implicit GBY )