---
title: "Discussion on \"MySQL | 实操：表的内连接\" | Hashnode"
description: "Discussion on \"MySQL | 实操：表的内连接\". 数据操作语言：表连接查询（二）\n内连接查询联系1\n\n查询底薪超过公司平均底薪的员工信息？\n\n# 查询底薪超过公司平均底薪的员工信息？\nSELECT e2.empno,e2.ename,e2.sal\nFROM t_emp e1 JOIN t_emp e2 WHERE e2.sal>=AVG(e1.sal);\n\nSELECT e.empno,e.ename,e.sal\nFROM t_emp e JOIN \n(SELECT AVG(sal) avg FROM t_emp) t\nON e.sal>=t...."
url: "https://hashnode.com/posts/mysql-or-shi-cao-biao-de-nei-lian-jie/628d9496bc26026fa45c547f"
---

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

Discussion

# [MySQL | 实操：表的内连接](https://hn.icodeq.com/mysql-or-shi-cao-biao-de-nei-lian-jie?utm_source=hashnode&utm_medium=feed)

数据操作语言：表连接查询（二） 内连接查询联系1 查询底薪超过公司平均底薪的员工信息？ # 查询底薪超过公司平均底薪的员工信息？ SELECT e2.empno,e2.ename,e2.sal FROM t\_emp e1 JOIN t\_emp e2 WHERE e2.sal>=AVG(e1.sal); SELECT e.empno,e.ename,e.sal FROM t\_emp e JOIN (SELECT AVG(sal) avg FROM t\_emp) t ON e.sal>=t....

May 16, 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.