SUM Function in SQL | Oracle SQL fundamentals
The SUM() function calculates the sum of a set of values.
Unlike other #SQL #aggregate #functions, the #SUM() function accepts only the expression that evaluates to numerical values.
You can specify either ALL or DISTINCT #modifier in the SUM() function.
The DISTINCT modifier instructs the SUM() function to calculate the total of distinct values, which means the duplicates are eliminated.
The ALL modifier allows the SUM() function to return the sum of all values including duplicates. The SUM() function uses the ALL modifier by default if you do not specify any modifier explicitly.
Website: https://www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis