Interested to Buy Any Domain ? << Click Here >> for more details...
He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?
- 3 Answers
- 8682 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
What is your approach when requirements change continuously?
do we need to write test cases for workflow of the product for instance: there is 2 module "TRAINING ASSIGN MODULE" and "EMPLOYEE" in TRAINING assign MODULE iam assigning training to employee setp is 1.selct traning "oracle" 2.select employee u want assign "peter" 3.apply. now to check whether training assign or not GOTO EMPLOYEE module 1.click on "peter" 2.click on 'view assign to employee'link.now this is a flow do i need to write test cases for this fllow.plz help me guy mail me nirmal_rawatt@rediff.com
what are the status have in QC(Test Management Tool). and how you report?
what are the various techniques you will use as soon as the srs was given to you to speedup the testing?
What is difference between cmmi and cmm levels?
Hello can anybody list out supported and unsupported browsers for Window OS,Android OS,MAC OS Ubuntu
Could some one tell me test cases for multi line text boxes like Notes field?
Please explain how to elaborate on the types of system/functionality for testing Payments, Statements, & Transactions features in a bank.....like what do we test in these,in detail? It's urgent, please reply...thanks in advance.
What is Stability and Performance Testing in Testing the TV
1.What is bidirectional traceability ??? and how it is implemented? 2.What is Automation Test frame work ? 3. Define the components present in test strategy? 4. Define the components present in test plan? 5. Have u written Test plan ?…. thank u!plz reply........
What is decision table testing?
What is rapid application development model (rad)?
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 .
In testing environment have you ever found any areas for improvement while you at work. (Please give some real life example).
I am a ISTQB cerfity tester with 3 yrs experience(kolkata) , I left my current commpany due to some problem but since two months I did not get new job , why? is my age is 33 yrs and I am married . If anybody have any answer please let me know, my email id sangitadas1981@gmail.com/yahoo.co.in
