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
- 8693 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 type of risk analysis u did in a banking projects...? Give an example...?
What is difference between Regression and Restesting?
What type of testing process is going on your company ?
i want manual and automation test cases and interview questions
What are the two ways to create test scripts?
If we found a bug but that bug is not accepted by developer then what u do.
What is XML Testing? Do we have any tools to test the XML? Please let me know.
what are 5 common problems in software development process?
How does compatibility testing differ while testing in Internet explorer and testing in Firefox?
Example for a bug not reproducible ?
system testing or sub system testing ? both are same or different ?
I would like to know about the steps to follow for testing a .NET web application. Please provide detailed steps with more general scenarios.
Automation Testing 
