Which SQL clause is used to filter aggregated group records after a `GROUP BY` statement has been applied?
Answer and explanation
Correct answer: C. `HAVING`
- Step 1: In SQL execution order, the `WHERE` clause filters individual rows before grouping occurs.
- Step 2: To filter grouped results based on aggregate functions (e.g., `COUNT(*) > 5`), the `HAVING` clause is mandatory.
Answer
`HAVING`.
Why not the others: '`WHERE`' filters rows prior to aggregation; '`ORDER BY`' sorts the output rows; '`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?
- 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…
- What is the binary representation of the decimal integer 25?