求助這道題怎么寫
uj5u.com熱心網友回復：
select project.Project_id,project.employee_id,max(employee.experience_years) as experience_yearfrom project inner join employee on project.employee_id=employee.employee_id
group by project.Project_id,project.employee_id
uj5u.com熱心網友回復：
select c.project_id, a.* from employee aJOIN project c ON a.employee_id=c.employee_id
where 1 > (select count(*) from employee where experience_years> a.experience_years )
/*
project_id employee_id name experience_years
1 1 Khaled 3
1 3 John 3
2 1 Khaled 3
*/
uj5u.com熱心網友回復：
select c.project_id, c.employee_idfrom (select a.*, b.*, rank() over(partition by a.project_id order by b.experience_years desc) rn
from project a join employees b
on a.employee_id = b.employee_id) c
where rn = 1
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/77763.html
標籤：應用實例
上一篇：增刪改查