#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-05-25 17:52:39 发布
#2.非等值连接#案例1:查询员工的工资以及对应的工资级别SELECT * FROM job_grades; SELECT e.salary,g.grade_levelfrom employees e,job_grades gWHERE e.salary BETWEEN g.lowest_sal andg.highest_sal; SELECT e.salary,g.grade_levelfrom employees e,job_grades gWHERE e...
摘要由CSDN通过智能技术生成