Multiple choice technology databases

Limiting the rows in a select statement for a specific condition is done by the clause

  1. Distinct

  2. Projection

  3. Where

  4. All of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The WHERE clause is used to filter rows based on specific conditions. DISTINCT removes duplicates, and projection refers to selecting specific columns (not limiting rows).

Keep practicing — related questions