Answer / naveen kamatam

select a.employee_id,a.first_name,a.manager_id,b.first_name
from test a inner join test b
on a.manager_id=b.employee_id order by 1

Answer / nandini p

For that you can use self join.
With in organization you will get manager name and their
mangers name, entire chain if you know the mangerid.

Answer / sneha.va

Suppose 2 tables;
Employee : having columns
empid,empfirstname,emplastname,MangerID
Manager : ManagerID, Managername

SELECT A.EMPFIRSTNAME,B.MANAGERNAME FROM EMPLOYEE A INNER
JOIN MANAGER B
ON A.MangerID = B.MangerID

waht is the quality in your company?

5 Answers  

---

As experienced what could be the interview questions based on project? It's urgent

6 Answers   ABC, P2Softech, Sony,

---

Give me examples for high priority and low severity defects?

6 Answers   AppLabs,

---

when testing will starts in a project?

12 Answers   Ordain Solutions,

---

can anybody tell me .. in realtime how cookies testing is actually done by the tester? And Test case is needed for cookies testingor not required?

0 Answers  

---

Who will assign the work to Test Engineer?

3 Answers   Si Systems, Wipro,

---

Hi! I have got an expirence of a year in Software(manual) testing...Kindly let me if there are any openings for the same,location :MUMBAI..i have got a knowledge of C++,sql (basic),java,and have done a automation testing course..

1 Answers  

---

I would like to know about the steps to follow for testing a .NET web application. Please provide detailed steps with more general scenarios.

3 Answers  

---

tell me about ur current project???

2 Answers   Philips,

---

Give me few testcases(5) of any application other than login related!

2 Answers  

---

can you tell me types of bug ?

1 Answers   IHS,

---

what is the general pattern of explanation of projects in interview, can u ans me plz.......... ex: online banking application

0 Answers  

---