If the DISTINCT keyword is not included in the SUM function,the ____ keyword will be assumed.
A) UNIQUE
B) ALL
C) RANDOM
D) none of the above

Question

If the DISTINCT keyword is not included in the SUM function,the ____ keyword will be assumed.​
A) ​UNIQUE
B) ​ALL
C) ​RANDOM
D) ​none of the above

Quizplus · Accepted Answer

If DISTINCT keyword is not included in the SUM function, the ALL keyword will be assumed. This means that all values will be included in the calculation, even if they are duplicates. Therefore, it is important to use the DISTINCT keyword in the SUM function when we want to perform the calculation only on unique values.

If the DISTINCT Keyword Is Not Included in the SUM