WRITE A SAMPLE QUERY FOR SELF JOIN?

Kamlakar Singh

Total Post:80

Points:400
Posted by  Kamlakar Singh
 890  View(s)
Ratings:
Rate this:
  1. Kamlakar Singh

    Post:80

    Points:400
    Write a sample query for self join?

    Select e1.ename, e2.empid from emp e1, emp e2 where e1.empid=e2.mgrid

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!