Guest User

Untitled

a guest
Jan 17th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. Gender Name Salary Id MentorID
  2. M Pourush 40000 1 2
  3. M Avinash 60000 2 Null
  4. F Surbhi 60000 3 Null
  5. F Kamakshi 40000 4 3
  6. F Ramya 60000 5 Null
  7. F Ritu 40000 6 5
  8.  
  9. SELECT e1.Name, e1.MentorId
  10. FROM Employee as e1, LEFT JOIN Employee as e2
  11. ON e2.Id<>e1.Id WHERE
  12. e2.Name LIKE 'Avinash' AND
  13. e2.Name LIKE 'Surbhi'
  14. AND e2.Name LIKE 'Ramya'
Add Comment
Please, Sign In to add comment