Multiple choice technology databases

Which SQL keyword is used to specify conditional search?

  1. SELECT

  2. WHERE

  3. SEARCH

  4. FIND

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The WHERE clause in SQL specifies conditions that rows must meet to be included in the result set. It filters data after the FROM clause retrieves it but before any grouping or aggregation happens. Without WHERE, all rows from the table are returned.