Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. Which SQL keyword is used to retrieve only unique values?

  2. A.

     DISTINCTIVE

    B.

     UNIQUE

    C.

     DISTINCT

    D.

     DIFFERENT

    View Answer

    Workspace

    Answer : Option C

    Explanation :

    This command is used to select the distinct rows.
    For Example: If we want to select all distinct department names from employee table, the query would be:
    SELECT DISTINCT dept FROM employee;


Be The First To Comment