Ai
1 Star 2 Fork 5

LilithSangreal/LeetCode-Solutions

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
克隆/下载
project-employees-iii.sql 758 Bytes
一键复制 编辑 原始数据 按行查看 历史
kamyu 提交于 2019-06-09 21:19 +08:00 . Create project-employees-iii.sql
# Time: O((m + n)^2)
# Space: O(m + n)
SELECT project_id,
p1.employee_id
FROM project AS p1
INNER JOIN employee AS e1
ON p1.employee_id = e1.employee_id
WHERE ( project_id, experience_years ) IN (SELECT project_id,
Max(experience_years)
FROM project AS p2
INNER JOIN employee AS e2
ON p2.employee_id =
e2.employee_id
GROUP BY project_id
ORDER BY NULL)
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/LilithSangreal/LeetCode-Solutions.git
git@gitee.com:LilithSangreal/LeetCode-Solutions.git
LilithSangreal
LeetCode-Solutions
LeetCode-Solutions
master

搜索帮助