Sail E0 Webinar
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.



Was this answer helpful ?
Next Question

Submit Solution

Your email address will not be published. Required fields are marked *

Latest Videos

Latest Test Papers