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

defination of testing

4 Answers  

---

what did your base to your test cases?

9 Answers  

---

What types of documentation are used in qa?

0 Answers  

---

what is agile testing when to perform this? have you performed agile testing anytime?please let me know more about this

2 Answers  

---

how you get build from developer? pl answer it?wht is build ?

4 Answers   Infotech,

---

10.What is stub?

5 Answers   Hewitt,

---

what are the microsoft six rules for usability?

4 Answers   AppLabs,

---

What are the Techniques to be followed while writing the Test Cases?

5 Answers   EDS,

---

WHAT ARE THE DOCUMENTS NEEDS TO BE SUBMITTED AS A PART OF TEST CLOSURE?

2 Answers   RBS,

---

What is Regression Testing?

22 Answers   IBM, Sapient, Siemens,

---

How the Error, Defect and Bug are related to each other ?.

12 Answers   FIC, Vinfotech,

---

Did you ever worked with BA's?

1 Answers   Standard Bank, Wells Fargo,

---