He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?
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 the criteria for selecting automation testing ?
Give me two reasons why the bug has not been fixed by developer ?
What is the difference between Bugzilla and Softsmith- QAMonitor?
what is the use of end to end testing?we r donig every testing like system and functional testing ect..
i got job selection order from decon engg hrd,tamilnadu,india.they are also demanding me 2000 rs. & saying that after 3 day they will give me a joinig letter, there web site is www.deconengg.net & postal address is decon engg(govt. hrd)no-236 coimbatore -641044.I submitted my resume to them and after that they didnt conduct any interview... can i believe this or its just a fake..
69 Answers Decon, ssinformatics,
What’s the difference between a bug and a defect?
how to select tese cases for automation.give me an example plz.
Please tell me difference btn Version & Reversion . Is there any difference btn them or both have same meaning.
What is smoke test? Do you use any automation tool for smoke testing?
Give me atleast 10 cases of GOOGLE search engine?
What is Management Testing?
how do u define quality of software?