If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.
A. Distinct
B. Count
C. Avg
D. Primary key
Answer:A
If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.
A. Distinct B. Count C. Avg D. Primary key
Explanation:Distinct keyword is used to select only unique items from the relation. 4. All aggregate functions except _____ ignore null values in their input collection.