Start learning →

Match the SQL clause

Exercise and reference answers

Matching pairs
  1. Left
    WHERE
    Right
    Enforces a condition
  2. Left
    DISTINCT
    Right
    Shows each value only once
  3. Left
    ORDER BY
    Right
    Sorts the result rows
  4. Left
    GROUP BY
    Right
    Gathers rows sharing a value
  5. Left
    BETWEEN
    Right
    A range including its ends
  6. Left
    IN
    Right
    Matches any value in a list
Instructions
Match each clause on the left to what it does.

Explanation

_Source: syllabus Computer Science, Ch 9 'Structured Query Language (SQL)'_
Continue learning with Quill →

Browse more IGNOU MCA questions and exercises →