0
1.上图两个表，要求找出掌握Skills中全部3个技能的员工，即神崎和相田，要求用mysql的语句实
2.刚学sql，不是很会，想了好久
3.下面是书里面用sql server写的，我也不是很理解，另外mysql中没有except
SELECT DISTINCT emp FROM EmpSkills ES1 WHERE NOT EXISTS (SELECT skill FROM Skills EXCEPT SELECT skill FROM EmpSkills ES2
Your Answer
1 answers
0
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));
对应的数据替换一下就可以了.
2016-11-08 15:37:57
Hot tools Tags
Hot Questions
How to send a POST request in Go?
2026-01-04 22:01:31
Replacing accented characters php
2026-01-04 21:43:20
custom listview adapter getView method being called multiple times, and in no coherent order
2026-01-04 21:22:09
Using RegEx to balance match parenthesis
2026-01-04 21:01:38
Asynchronous Requests with Python requests
2026-01-04 20:42:13
Popular tool
vc9-vc14 (32+64 bit) runtime library collection (link below)
Download the collection of runtime libraries required for phpStudy installation
VC9 32-bit
VC9 32-bit phpstudy integrated installation environment runtime library
PHP programmer toolbox full version
Programmer Toolbox v1.0 PHP Integrated Environment
VC11 32-bit
VC11 32-bit phpstudy integrated installation environment runtime library
SublimeText3 Chinese version
Chinese version, very easy to use
Hot Topics
Douyin level price list 1-75
20417
7
20417
7
wifi shows no ip assigned
13577
4
13577
4
Hot Article
How to set up price alerts so you don't miss key entry points?
2026-01-01
By DDD
Why do professional traders advise newbies to start with low leverage?
2026-01-01
By DDD
How to Fix a 'KERNEL_DATA_INPAGE_ERROR' on Windows?
2026-01-02
By 下次还敢
How to reverse a string in Python? (code examples)
2025-12-31
By 下次还敢