He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?
- 3 Answers
- 7408 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
How to write test case for view the table(i.e it is already stored in database and see the content in the table)
3. In a system designed to work out the tax to be paid: An employee has £4000 of salary tax free. The next £1500 is taxed at 10%. The next £28000 after that is taxed at 22%. Any further amount is taxed at 40%. To the nearest whole pound, which of these groups of numbers fall into three DIFFERENT equivalence classes?
What makes a good test engineer?
What is bug release?
What are the possible test scenarios around AVS check of any credit card? (Testing through payment gateway online) (What are the fields we should check while checking AVS and CVV)
What is Mixed Testing
How should your staff be managed? How about your overtime?
what is TAS language which is used as a language for some projects/
What kind of testing to be done in client server application and web application? Explain
Tell some examples of bug severity and bug priority?
Can you explain regression testing and confirmation testing?
What is decision table testing?
Can you explain process areas in cmmi?
what are the types of Bug?
What are the tasks of test closure activities in software testing?
