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
- 8435 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 |
what is bug triage?
How will be the communication between the testers and developers while found a bug?
Why Adhoc Testing is done?
Can anyone send me test plan for any website application for e.g. www.orkut.com or www.facebook.com please email me at disha_gupta83@yahoo.com
What impact ratings have you used in your projects?
tell me any bug which u could not able to find
What is Version Control?
Hi Friends, I have got 3 years of exp in IT industry in to Testing, working as Software test eng., in hyd.. kindly let me know any openings in Pune with this exp...contact @ swamyn.2k@gmail.com or pawan_your@yahoo.com
What procedure you follow between gathering requirements and carried out testing?
10.What is stub?
comptability testing with ui means,any body can expain me how we perform compatability testing in real time,don;t give definetions
what is the different between QA and test engineer?tell me in brief?
Automation Testing 
