Which SQL clause is used to filter rows based on a condition?

SQL Medium
Select the correct answer: Single Choice

Key points

  • The WHERE clause applies to individual rows, not groups
  • HAVING is used with aggregate functions, not for row-level filtering
  • FILTER is not a standard SQL clause, despite its intuitive name
  • LIMIT controls the output size, not the condition for inclusion

Ready to go further?