>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,

Apart from the answers given by others, on a more general note:
there's a lot a aggregating going on in your problem. Do you know that
analytic functions do not provide for this? You get an output row for
every input row.