Interested to Buy Any Domain ? << Click Here >> for more details...
He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?
- 3 Answers
- 8599 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 4 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
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
| Is This Answer Correct ? | 3 Yes | 2 No |
Please explain test matrices
What are the Test Deliverables?
10 Answers Banking, Burndy Technology and Global Business Services,
What is a test severity and test priority? difference between them with suitable examples?
Can anyone please tell in detail about the Rally tool and how a tester is going to use it.
which test comes first installation testing or compatiability testing
What is the Entry Point for Test Plan?
Can anyone tell me, What is wound fixing?
as test eng ,what challenges have u faced in ur 3 projects so far? tell me atleast 3 challenges in ur projects? july 27 brahma412@yahoo.co.in
Wht tools are used in Manual testing for bug tracking and reporting?
Can any one please explain me, what kind of defects we should not raise while doing System Testing?
Have u ever done testing related to a database,give examples to support u r answer.
What's the relationship between environment reality and test phases?
Automation Testing 
