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 from a table before any grouping or aggregation occurs. It applies row-level filtering based on specified conditions.