Junior — Middle

Have you used the HAVING operator in SQL queries?

sobes.tech AI

Answer from AI

Yes, the HAVING operator in SQL is used to filter the results of aggregate functions after grouping data with GROUP BY. Unlike WHERE, which filters rows before grouping, HAVING applies to grouped data.

Example: suppose you want to get a list of customers whose total orders exceed 1000.

SELECT customer_id, SUM(order_amount) AS total
FROM orders
GROUP BY customer_id
HAVING SUM(order_amount) > 1000;

Here, HAVING filters customer groups based on the total order amount condition. This is useful when you need to select groups based on aggregated values.

Previous Next