题目
有如下两张表 G1122A 表:
G1122B 表:
查询出每个项目中经验最丰富(experience_years最大)的员工,返回的结果如下:
说明:员工1和3是project_id为1中exprerience_years最丰富的, 而project_id为2的项目,员工id为1的是exprerience_years最丰富
测试数据
CREATE TABLE G1122A
(project_id INT,
employee_id INT)
INSERT INTO G1122A VALUES
(1,1),
(1,2),
(1,3),
(2,1),
(2,4);
CREATE TABLE G1122B (employee_id INT,
name VARCHAR(20),
experience_years INT
)
INSERT INTO G1122B VALUES
(1,'张三',3),
(2,'李四',2),
(3,'王五',3),
(4,'马六',2)