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 filters rows based on specified conditions. DISTINCT removes duplicates, Projection selects specific columns, and neither limits rows based on conditions. Only WHERE applies conditional filtering to rows in a SELECT statement.

Keep practicing — related questions