Hi All

Lets say I have one table in below format.

EmployeeID.............. Skill
------------------------------------------------------
1...............................PHP
1...............................SQL
1...............................Java
1................................VoIP

2................................Shell Scripting
2................................PHP
2................................Java

3............................... C++
3................................C
3.................................Pearl

I wan to do a SQL query for employess who MUST have skill PHP and Java.
As per above table, the query result should show Employee 1 and 2.

Now what should be the corresponding SQL query for it.

Regards
Austin

Reply via email to