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);






评论(0)


暂无数据
推荐帖子
0条评论
0条评论
0条评论