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, returning only those rows that satisfy the criteria. DISTINCT removes duplicate rows, while projection refers to selecting specific columns in a SELECT statement.

Keep practicing — related questions