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
Our software designers use UML for modeling applications. Based on their use cases, we would like to plan a test strategy. Do you agree with this approach or would this mean more effort for the testers.
On login window for username and password auto populated field means what !
Could anyone share FAQs for Test Manager position...
What are the standard you follow in your company to prepare test plan document? Content is same in every standard or not. Also is there any document to read about the testing standards? Thanks in advance for giving me the answer.
Hi Could someone please provide Siebel Testing Interview questions for 5 years exp.
i looking for the software testing job with the exp of (1.5 yrs ), if anybody knows how to approach the companies ,pls let me know , possible que which will be asked in interview ? pls send me sample resume for testing ....pls do the favour as soon as posible .
integration test cases for mouse and keyboard
what r the 5 major defects that u found in ur shopping related project?
Define brain stromming and cause effect graphing?
how to test ecg machine?
Hello everybody, How many people do you think one sprint team can have in average?
Can i get answers for telecom testing for eg telecom billing rating can be tested
hi friends i recently finished testing course in hyderabad.now am looking for a job in uk.i need help about the projects in interview point.can any one explain me abt banking project or credit card.like what are the problems faced in u r last project etc.
What are the benefits of requirement traceability?
Test approach to windows scheduler?