Question -
Select count (____ ID)from teacheswhere semester = 'Spring' and year = 2010;If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.
Options:
A .  Distinct
B .  Count
C .  Avg
D .  Primary key
Answer: Option A
DistinctDistinct keyword is used to select only unique items from the relation.
Submit Your Solution hear: