Question: In SQL, which clause is used to filter records after grouping?
Options:
WHERE
HAVING
GROUP BY
ORDER BY
Correct Answer: HAVING
Solution:
The HAVING clause is used to filter records after grouping in SQL.
In SQL, which clause is used to filter records after grouping?
Practice Questions
Q1
In SQL, which clause is used to filter records after grouping?
WHERE
HAVING
GROUP BY
ORDER BY
Questions & Step-by-Step Solutions
In SQL, which clause is used to filter records after grouping?
Correct Answer: HAVING
Step 1: Understand that in SQL, we often group records using the GROUP BY clause.
Step 2: Know that after grouping, we may want to filter the results based on certain conditions.
Step 3: Learn that the HAVING clause is specifically designed to filter records after they have been grouped.
Step 4: Remember that the WHERE clause is used to filter records before grouping, while HAVING is for after.
HAVING Clause – The HAVING clause is used in SQL to filter records that have been grouped by the GROUP BY clause, allowing for conditions to be applied to aggregate functions.
GROUP BY Clause – The GROUP BY clause is used to arrange identical data into groups, which can then be filtered using the HAVING clause.
Soulshift Feedback×
On a scale of 0–10, how likely are you to recommend
The Soulshift Academy?
