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
- 8686 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 JAVA Testing, what we do in That ?
what is Ping tests?
does regression testing start from 2nd build or 1st build?why?could u plz answer
difference between web based application and window based application
32 Answers Akash, Evox, iGate, Intelligrape, Lexicon, Semantic Space, SVICS,
How to get the testing experience of capital market or banking domain? Are there any demo applications/websites?
How to do integration testing on duster......
1.How can you Pick Integration Test Cases? 2.When will you start Regression Testing? 3.What is the difference between QA & QC? 4.When Will you Exit In Testing? 5.Test Deliverable's 6.What is the difference between windows based appln and web based appln? 7.What are the types of regression testing?
8)What is the actual need for an alpha and beta testing? A)For the developers it is impossible to predict how the end user with really use the application B)Misinterpretation of instructions for using the software C)End users may use strange combinations of input data D)All the above
what is the difference in smoke and sanity testing.?
HOW DO U EXECUTE THE CASES WHEN THE TIME IS NOT SUFFICIENT TO EXECUTE ALL THE TEST CASES?
What is a checklist? and wat are its contents??
How do you test the web application?
Automation Testing 
