热线电话:13121318867

登录
2019-03-04 阅读量: 720
SQL查询题目

问题描述:

上图两个表,要求找出掌握Skills中全部3个技能的员工,即神崎和相田。

解决方法:

MySQL:

SELECT DISTINCT emp FROM EmpSkills s WHERE NOT exists(SELECT skill FROM skills WHERE skill NOT IN
(SELECT skill FROM EmpSkills Es2 WHERE Es2.emp = s.emp));

SQL Server:

SELECT DISTINCT emp
FROM EmpSkills ES1
WHERE NOT EXISTS
(SELECT skill
FROM Skills
EXCEPT
SELECT skill
FROM EmpSkills ES2
WHERE ES1.emp = ES2.emp);

5.9738
1
关注作者
收藏
评论(0)

发表评论

暂无数据
推荐帖子