select project_id, employee_id from Project join Employee using (employee_id)
where (project_id, experience_years) in
(select project_id, max(experience_years) from Project join Employee using (employee_id) group by project_id);
Sql题库
最新推荐文章于 2024-07-18 15:32:08 发布