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

Explanation

The purpose of the FILTER clause in SQL aggregate functions is to apply a per-aggregate WHERE condition. This allows different aggregates in the same SELECT statement to filter on different predicates without the need for subqueries.

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