#2.非等值连接
#案例1:查询员工的工资以及对应的工资级别
SELECT * FROM job_grades;
SELECT e.salary,g.grade_level
from employees e,job_grades g
WHERE e.salary BETWEEN g.lowest_sal and
g.highest_sal;
SELECT e
MySQL非等值连接练习
最新推荐文章于 2024-07-24 16:11:19 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)