Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Question about query with SUM
select Id, Sum( Usage )
from <table>
group by Id;
Regards,
Aleksandr Kononov
In article <3A4936C1.35597C57_at_exit109.com>,
Rolf Kamp <rfk_at_exit109.com> wrote:
> Hi:
> I have a table with 2 rows:
> - ID (a varchar)
> - usage (a number)
>
> Presently, I have a query that returns the distinct IDs in the
> table, then I query the table and SUM(usage) for each unique ID. I
would
> like to have oracle do both steps for me in 1 query. So far I have
this:
>
> select distinct ID, SUM(USAGE)
> from USAGE;
>
> But I get an error stating "Not a single group function".
>
> Any help is greatly appreciated.
> - rfk
>
>
Sent via Deja.com
http://www.deja.com/
Received on Wed Dec 27 2000 - 00:36:20 CST