What is the purpose of the FILTER clause in SQL aggregate functions?

SQL Fundamentals Hard

SQL Fundamentals — Hard

What is the purpose of the FILTER clause in SQL aggregate functions?

Key points

  • FILTER clause enables per-aggregate filtering
  • Useful for applying different conditions to different aggregates
  • Eliminates the need for subqueries for filtering aggregates

Ready to go further?

Start full exam Practice more questions

Related questions