Basics & SELECT Queries · SQL SQL
Which of the following clauses is used to filter rows after aggregate functions have been computed?
Practice question from Basics & SELECT Queries (SQL SQL), with the correct answer and a step-by-step solution.
medium · MCQ · Q-CA0BC1
Which of the following clauses is used to filter rows after aggregate functions have been computed?
- A.WHERE
- B.HAVINGCorrect answer
- C.GROUP BY
- D.FILTER
Solution
The HAVING clause is specifically designed to filter groups created by GROUP BY based on aggregate conditions. The WHERE clause filters individual rows before aggregation occurs.
More from Basics & SELECT Queries
- Which of the following clauses is evaluated first during the logical execution of a standard SQL SELECT query?
- What is the primary purpose of the DISTINCT keyword in a SELECT statement?
- Consider a table named employees with a column salary. Which query correctly retrieves all rows where the salary is between 40000 and 60000…
- How does SQL handle NULL values when comparing them with standard comparison operators like equals (=) or not equals (<>) in a WHERE clause?
Practise more SQL
Sign up free for adaptive practice on this chapter, with instant feedback and hints on every question.
Start practising freeFree to start · No credit card needed