使用IN子查询查找职级为“一级教授”和“二级教授”的职工姓名、性别和工作年限。

img


使用IN子查询查找职级为“一级教授”和“二级教授”的职工姓名、性别和工作年限。

SELECT tbl_employees.name, tbl_employees.gender, DATEDIFF(NOW(), tbl_employees.starting_date) AS working_years
FROM tbl_employees
WHERE tbl_employees.rank_title IN (
SELECT rank_title
FROM tbl_rank_salary
WHERE rank_title = ‘一级教授’ OR rank_title = ‘二级教授’
)
ORDER BY working_years DESC;