Question about query with SUM

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 Received on Tue Dec 26 2000 - 18:24:33 CST