Hi. I have a table where I want to sum the amounts in one column in rows that share a value in a second column. This seems like a simple thing to do but I can't figure it out. I've explored using cursors and tried comparing the table to a list of distinct key_field values but it's not working for me. Any suggestions? Thanks.

amount key_field
8000 1
25000 1
1800 2
2500 2
8996 2

Hi Justine,

The problem is not very clear; do you want to find the sum of all amounts for key_fields 1 and 2 ?

SQL> desc t3
 Name Null? Type
 --------------------------- -------- ------------------
 AMOUNT NUMBER
 KEY_FIELD NUMBER

SQL> select * from t3;

    AMOUNT KEY_FIELD
---------- ----------
      8000 1
     25000 1
      1800 2
      2500 2
      8996 2

SQL> select key_field, sum(amount) "Sum of Amounts"
  2 from t3
  3 group by key_field;

 KEY_FIELD Sum of Amounts
---------- --------------
         1 33000
         2 13296

SQL>

Cheers,
Prat