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
- 8569 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 |
How to test gtalk applicatin,what could be the possible test cases,test plan
can any help the difference b/w incremental integration testing & integration testing & system & funtional testing
What is bug life cycle?Explane with example
what is the diff b/w local and global variable?
What is meant my Firewall testing? how the testing is performed on it?
What is meant code review?
what is the need to write testcases??? cant u test ur application with SRS?? y u have to write testcase document??
what are the Cs in testing
what is difference between win 98 and win 2000 poertating system?which is better one?
what is agile testing
What is the need of smoke test even when unit test is done by developers?
what is FAT and SAT tests .?
Automation Testing 
