Get sum of column with distinct id in SQL

Question

I am trying to get sum of the amount on distinct ext_id.

Select SUM(amount) from Table1 -- this will get me sum of all => 36

I want just sum of distinct Ext_id which should be 23. Can someone help me with this? THanks in advance!

Does this answer your question? [Trying to sum distinct values SQL](https://stackoverflow.com/questions/18218108/trying-to-sum-distinct-values-sql) — VladNeacsu, Apr 09 '21 at 05:25

score 1 · Accepted Answer · answered Apr 08 '21 at 18:59

1

You can use two levels of aggregation:

select sum(avg_amount)
from (select ext_id, avg(amount) as avg_amount
      from t
      group by ext_id
     ) x

answered Apr 08 '21 at 18:59

Gordon Linoff

1 Answers1