Home > DeveloperSection > Interviews > Write a sample query for self join?

Posted on    October-13-2014 11:37 PM

 MSSQL Server Database  MSSQL Server 
Ratings:
 1 Answer(s)
  659  View(s)
Rate this:

Kamlakar Singh
Kamlakar Singh

Total Post:80

Points:400
Posted on    October-13-2014 11:37 PM

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

Don't want to miss updates? Please click the below button!

Follow MindStick