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

SQL Data Analyst Medium

SQL Data Analyst — Medium

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

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?

Start full exam Practice more questions

Related questions