Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Gender Name Salary Id MentorID
- M Pourush 40000 1 2
- M Avinash 60000 2 Null
- F Surbhi 60000 3 Null
- F Kamakshi 40000 4 3
- F Ramya 60000 5 Null
- F Ritu 40000 6 5
- SELECT e1.Name, e1.MentorId
- FROM Employee as e1, LEFT JOIN Employee as e2
- ON e2.Id<>e1.Id WHERE
- e2.Name LIKE 'Avinash' AND
- e2.Name LIKE 'Surbhi'
- AND e2.Name LIKE 'Ramya'
Add Comment
Please, Sign In to add comment