In SQL, which clause filters aggregated group results produced by a `GROUP BY` statement?
Answer and explanation
Correct answer: A. `HAVING`
- Step 1: `WHERE` filters individual table rows prior to grouping.
- Step 2: `GROUP BY` aggregates rows into summary groups based on matching column values.
- Step 3: `HAVING` filters group-level summary records based on aggregate conditions (e.g. `HAVING COUNT(*) > 5`).
Answer
HAVING.
Why not the others: '`WHERE`' cannot contain aggregate functions; '`ORDER BY`' sorts results; '`DISTINCT`' removes duplicate rows.
Practise more Python Programming, Data Structures, Algorithms, Networks and Cybersecurity.
Free questions with an explanation for every one, and full timed Saudi Secondary School Certificate mock tests.
More Python Programming, Data Structures, Algorithms, Networks and Cybersecurity questions
- What is the time complexity of searching for an element in an unsorted array of elements using linear search?
- What is the output of the following Python expression: `[x**2 for x in range(5) if x % 2 == 1]`?
- Which data structure operates on a Last-In, First-Out (LIFO) access principle?
- Which SQL clause is used to filter aggregated group records after a `GROUP BY` statement has been applied?
- What type of network topology connects all nodes to a central forwarding device such as a network switch?
- In cybersecurity, what type of malicious attack overwhelms a web server with massive volumes of traffic from multiple compromised sources to…