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
- 8480 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 |
You find a bug and the developer says “It’s not possible” what do u do?
hi tell me different testing methodologies
what is the critical defect in telecom domain?help me out from this prob its very urgent
I am doing manual testing for one website application. already i had prepared test case report,bug tracking report. now i need to perform functional testing of the application and prepare function test report. so can u send one model of the functional test report to me.. it is very helpful to me. my id is sunaruna84@gmail.com
what is vss?
Guys, can any one of u give the realtime example for Unit Testing?
What are the points to be considered while testing an application on different browsers like firefox, opera, mozilla, ie etc. on both windows & linux ??
Give the real-time example for back-to-back testing?
Write UI Test case, Integration Test case, Functional Test case & Performance Test case for the File Menu for MS-Word?
hi how to test a video files? and what type of test stategy you follow to test a video files?
advantages of test plan in software testing? the interviewer asked what is the use of test plan, as we always dont follow the test plan.
What is the diffrence between product base company and application company ? if product base name few products,if service base name the few services.
Automation Testing 
