Menu
Home / CSE MCQs / DBMS MCQs :: Discussion

Discussion :: DBMS MCQs

  1. Select count (____ ID)
    from teaches
    where semester = 'Spring' and year = 2010;
    If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.
    2. A.
    Distinct
    B.
    Count
    C.
    Avg
    D.
    Primary key

    View Answer

    Workspace

    View Answer

    Answer : Option A

    Explanation :

    Distinct

    Distinct keyword is used to select only unique items from the relation.

Write your comments here:

Be The First To Comment