What does the FILTER clause do when used with aggregate functions in SQL?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

What does the FILTER clause do when used with aggregate functions in SQL?

Key points

  • The FILTER clause applies a per-aggregate WHERE condition.
  • It helps avoid the use of multiple subqueries for filtering.
  • Each aggregate function can have its own specific predicate.
  • This enhances efficiency in SQL queries.

Ready to go further?

Start full exam Practice more questions

Related questions