He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?
Answer Posted / 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 |
Post New Answer View All Answers
Write a set of test cases to test youtube?
which sanity testing is performed?
What is the difference between functional requirement and non-functional requirement?
what is e-tester?
Hi I want to start online training couses for testing Any body plz help me out how to start the online courses Plz post the answer here or send me a mail for kommineni.1020@gmail.com
I have interview on Guide wire testing. If you please share me.
What is security Hole ? Is this possible Some one can acess any of restricted page (like admin side)? How you test this previllaze?
Hi there Does anybody can respond to my Questions? Is some one there to answer my Questions posted in Software testing category.pls E-mail to sunitht27@yahoo.com
What icon is used in WinRunner to get an explanation of the syntax of TSL?
What is un-installation testing?
Is anybody have the telecom systems test cases from start to end?
what is test case management?explain in brief.
Can you explain equivalence partitioning?
how deployment phase of SDLC differs in product based and in service based company ?
i heard that mainframe testing is diff from other environments & has lot of keyboard input????pl clarify my doubt & let me know in what way its diff??