analytic functions vs subquery

Hello, let's suppose I have this denormalized table:

         ID NUM
---------- ----------

          1          7
          1          7
          1          7
          2          9
          3          9
          4          3
          4          3

I wish to sum the NUM values but I wish to take just one NUM for each distinct ID value, e.g.:

7+9+9+3

I'm trying to find a way to do that using analytic functions instead of a subquery. Any hints?

(of course select distinct(num) is not an option here)

Thank you. Kind regards,

-- 
Cris Carampa (cris119_at_operamail.com)



- We're gonna be like three little Fonzies here. And what's Fonzie like?

- Cool?