Oracle SUM() Aggregate Function By Practical Examples
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