#子查询的课后练习
#查询和Zlotkey相同部门的员工部门和工资
SELECT last_name,salary
FROM employees
WHERE department_id IN (
SELECT department_id
FROM employees
WHERE last_name = 'Zlotkey'
);
#选择工资大于所有JOB_ID = ‘SA_MAN’的员工的工资的员工的last_name,job_id,salary
SELECT last_name,
子查询课后练习
最新推荐文章于 2023-08-08 17:23:31 发布