Hi,
I have a table candidateSkills where I store the skillName
and skillDuration. The table looks like:
skillid | ReumeId| skillName | skillDuration |
---------------------------------------------
1. | 1 |
java | 32 |
2. | 1 |
jsp | 43 |
3. | 1 | oracle | 34 |
4. | 2 | jsp | 48 |
5. | 2 | oracle | 83 |
6. | 3 | jsp | 67 |
I want to query such that I get the resumeid where
the skillName is jsp and the skill duration is > 10
and the skill name is oracle and skillDuration is > 15.
While I was using oracle, the sql query that worked was
SELECT ResumeId from candidateSkills where skillName = 'jsp' AND
skillDuration > 10
INTERSECT
SELECT ResumeId from candidateSkills where skillName = 'oracle' AND
skillDuration > 15
The output was [1, 2]
But, I see that mysql does not support intersect. How do I go about ?
Please advice.