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@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 )

Received on Thu Mar 13 2003 - 11:32:14 CST