Menu
Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. Let the statement
    SELECT column1 FROM myTable;
    return 10 rows. The statement
    SELECT ALL column1 FROM myTable;
    will return

    2. A.

     less than 10 rows
    B.

     more than 10 rows
    C.

     exactly 10 rows
    D.

     None of these

    View Answer

    Workspace

    View Answer

    Answer : Option C

    Explanation :

    ALL are optional. Its presence or absence doesn't change the output. Unlike DISTINCT, it allows duplicates in the output.

Write your comments here:

Be The First To Comment