He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?
- 3 Answers
- 7441 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
On what basis you are fixing up the time for project completion?
tell me brief about your project? please help me how to explain the project what is the flow? my current project is ERP domain web based application. please help me
Which is the best testing model?
in the account there is 10,000 rupees and i entered 20000, in this case how will you test the application
Explain stub in testing point of view?
Why documentation testing is important?
Hello testers I am an Bsc Hotel mgmt Degree holders but now am doin my software testin programme, side by MCA Master degree an have 6 months exp i testing in company.. i want to change my CV according IT based. so can anyone help me with sendin any sample CV of urs.. do me this favour it wil be very helpful for me prepare CV for interviews....
Are there more defects in the design phase or in the coding phase?
How to derive test data from the design documents?
How to test the Online Games?? Suggest tricks. I have experience in server-client application testing.
Hi Friends, I have completed 3 rounds of an Interview with HR discussion also and got Offer letter from Cognizant, but after in 30 min they send one more email like Offer is on Hold, and its not valid... Could you please guide me any one , Can i expect Offer again from Cognizant or Can i drop the hopes ?.
Tell some examples of bug severity and bug priority?
I have 2 yr Localisation testing exp now i want to job in MNC My manualtesting knowledge+2 yr exp sufficiant for in MNC
Hi Friends, I want to know the best institute in hyderabad which is giving training in 'SAP Testing' and who is the best faculty. Regards, Imtiyaz..
What are the various techniques in black box testing?
