Question · SQL and MySQL course · Module 11: Capstone project

The role of the WHERE clause

What is the purpose of the WHERE clause in a SELECT query?

Answer options

  • It filters rows - it returns only those that meet the given condition
  • It sorts the results alphabetically
  • It joins two tables
  • It removes columns from the table

You can check the correct answer by solving this task in the CodeWorlds game.