---
title: "Discussion on \"MySQL | Having子句的使用\" | Hashnode"
description: "Discussion on \"MySQL | Having子句的使用\". 数据操作语言：HAVING 子句\n分组查询遇到的困难？\n\n查询部门平均底薪超过2000元的部门编号\n\n错误示范\nSELECT deptno FROM t_emp\nWHERE AVG(sal) >=2000 -- 错在这里出现了聚合函数\nGROUP BY deptno;\n\n引入 HAVING 子句\nSELECT deptno\nFROM t_emp\nGROUP BY deptno HAVING AVG(sal)>=2000;\n\nHAVING 子句的用途\n\n查询每个部门中，1982 年以后入职的员工超..."
url: "https://hashnode.com/posts/mysql-or-having-zi-ju-de-shi-yong/628d944db4bd016fc9a32984"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [MySQL | Having子句的使用](https://hn.icodeq.com/mysql-or-having-zi-ju-de-shi-yong?utm_source=hashnode&utm_medium=feed)

数据操作语言：HAVING 子句 分组查询遇到的困难？ 查询部门平均底薪超过2000元的部门编号 错误示范 SELECT deptno FROM t\_emp WHERE AVG(sal) >=2000 -- 错在这里出现了聚合函数 GROUP BY deptno; 引入 HAVING 子句 SELECT deptno FROM t\_emp GROUP BY deptno HAVING AVG(sal)>=2000; HAVING 子句的用途 查询每个部门中，1982 年以后入职的员工超...

Apr 27, 2022 · 1 min read · hn.icodeq.com  
Read the article

## Written by

[zhou keqiang](https://hashnode.com/@zkeq)

@zkeq

  
[View profile](https://hashnode.com/@zkeq)

Creating And Studying .

## Responses

Markdown supported · ⌘↵ to post

No responses yet.