**Oracle SUM() Aggregate Function By Practical Examples**
https://www.oracletutorial.com/oracle-aggregate-functions/oracle-sum/

The Oracle SUM() function accepts a clause which can be either DISTINCT or ALL.. The DISTINCT clause forces the SUM() function to calculate the sum of unique values.; The ALL clause causes the SUM() function to calculate the sum of all values, including duplicates.; For example, the sum of DISTINCT of 1, 1, and 2 is 3, while the sum of ALL of 1, 1, and 3 is 4.. If you omit the clause, the SUM ...

**DA:** 76 **PA:** 100 **MOZ Rank:** 83