HAVING is used to filter grouped results, while WHERE filters rows before grouping.

Question

HAVING is used to filter grouped results, while WHERE filters rows before grouping.

BlackTom AI · Accepted Answer

WHERE restricts individual rows before any grouping or aggregation occurs, while HAVING applies conditions to groups after GROUP BY and aggregation have been computed.

1) Relevant knowledge points and concepts
- WHERE filters raw rows; it cannot use aggregate functions (e.g., COUNT(), SUM()).
- GROUP BY collects rows into groups; aggregate functions compute values per group.
- HAVING filters those groups and can use aggregate functions.
- SQL allows HAVING without GROUP BY in some cases to filter an aggregate over the whole result, but normally HAVING is used after GROUP BY.

2) Step-by-step reasoning with an example
Consider a table employees(dept, salary) with rows:
1. (A, 60000)
2. (A, 45000)
3. (A, 70000)
4. (B, 55000)
5. (B, 48000)

SQL: SELECT dept, COUNT(*) AS cnt FROM employees WHERE salary > 50000 GROUP BY dept HAVING COUNT(*) > 1;

Step A — Apply WHERE salary > 50000 (row-level filtering):
- Remaining rows: (A,60000), (A,70000), (B,55000)

Step B — GROUP BY dept and aggregate:
- Group A: COUNT(*) = 2
- Group B: COUNT(*) = 1

Step C — Apply HAVING COUNT(*) > 1 (group-level filtering):
- Group A remains (cnt=2). Group B is removed (cnt=1).

3) Intermediate steps illustrated (as above)
- Original 5 rows → after WHERE: 3 rows → after GROUP BY counts: A=2, B=1 → after HAVING: only A.

4) Why the correct answer is correct
The statement exactly matches SQL semantics: WHERE filters rows before grouping; HAVING filters grouped results. HAVING can use aggregates to decide which groups to include, something WHERE cannot do.

5) Why the other option (False) is incorrect
Saying the opposite would claim HAVING filters rows before grouping or that WHERE filters after grouping — both contradict SQL rules. WHERE cannot use aggregate expressions and cannot filter groups; thus False is incorrect.

6) Conclusion
The correct answer is True, which matches the provided answer.

HAVING is used to filter grouped results, while WHERE filters rows before grouping.判断题

类似问题

SELECT the SQL statement that lists the five highest paid employees

Select the SQL Statement will list the first name, last name and calculate the number of years the staff member has been employed.

Select the SQL Statement that will count all of the office locations that are in Australia

Select the SQL statement that will list the first name and last name of staff, and order the result by the last name in alphabetical order.

Which of the following SQL statements can be used to select all the records from a table named "Persons" where the "firstName" is "Joe"?

Which SQL statement below does the following MongoDB script most closely correspond to? db.students.find( {age: 18}, {name: 1, _id :0} )

tblScores [table] StudentID | Score 1 | 54 2 | 53 3 | 52 4 | 51 5 | 50 6 | 49 7 | 48 8 | 47 9 | 46 10 | 50 [/table] Query1SELECT StudentID, ScoreFROM tblScoresWHERE Score > 50 If Query1 was run on the table how many records would be returned?

Select all statements that correctly match SQL clauses to their function.

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单