Multiple choice technology databases

Which clause in a query limits the rows selected?

  1. ORDER BY

  2. FROM

  3. SELECT

  4. WHERE
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The WHERE clause in SQL queries is specifically designed to filter rows based on conditions, limiting which rows are returned by the SELECT statement. FROM specifies the table source, SELECT chooses columns, and ORDER BY sorts the results. Only WHERE actually limits the rows selected based on criteria.

Keep practicing — related questions