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

What are the Level of Severity

11 Answers   Atlantic Scientific, Deloitte,

---

What does a manual tester need to become proficient with db testing?

0 Answers  

---

1.Unit testing ->integration testing->system testing->UAT in this where do u do the functional testing & regression testing? if these two done in each phase why should not mentioned in that ?

6 Answers   ITC Infotech,

---

Explain about Founctionality Testing in webbased application?

1 Answers   Crea,

---

Why you think tester is more important for good quality of the product?

9 Answers  

---

I want to know the real time cycle i.e SDLC.(First of all Buisness logic is prepared,but doesn't know by whom and with the help of whom?)Similarly what are the next steps (the persons involved) and connection in between the steps.

5 Answers   Quexst,

---

How will you test language converter e.g. (English to Spanish) without Automation tool? OR What are the test cases or scenarios for language converter? Conditions: 1. without Automation tool, 2. You know only English language. 3. Make sure the tests should produce 80-90% pass result.

2 Answers   Mastek,

---

developers take most of the time for coding and tester left very few time for testing say 2 days which testing u find best when ur project is run out of time and product is going to be released

3 Answers  

---

which situation will decide the approach (topdown/bottom up) to choose from?

2 Answers  

---

Which testing approach you follow to test ATM machine?

1 Answers  

---

What is the most important phase in STLC and Why

0 Answers  

---

Difference between adhoc testing and error guessing?

0 Answers  

---