He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?
Answer Posted / nandini p
For that you can use self join.
With in organization you will get manager name and their
mangers name, entire chain if you know the mangerid.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the various techniques in white box testing?
What is function points??????
1.How can you Pick Integration Test Cases? 2.When will you start Regression Testing? 3.What is the difference between QA & QC? 4.When Will you Exit In Testing? 5.Test Deliverable's 6.What is the difference between windows based appln and web based appln? 7.What are the types of regression testing?
what is test case management?explain in brief.
1.What is configuration Management? 2. Explain Impact Analysis 3. Explain Peer Review 4. what i kickoff phase of Formal Review. 5. Whatv are the phases of fundamental test process. 6. what is state transition testing. 7. what is LCSAJ 8. Test conditions are derived from where?
Which test cases are written first: white boxes or black boxes?
What is test startegy?
what are risks and contigencies(solutions) of an ecommerce (online shopping and bidding project)application?we describe this in Test plan can anyone tell me abt this?
hi, I m looking for a career in manual web testing. so PLZ anybody who have the practical knowledge of dis field help me. GIVE ME UR MAIL ID so that i can ask regarding some doubts. my MAIL ID is ankurtester819@gmail.com
What is alpha testing?
What is a good test? Wy do we need testing write test steps for triangle write test steps for ATM How a tester should approach a devloper about non accepted defect? What is test coverage assurance and give an example Draw and expain V model and how it is helpfull in software development
what is agile model and spiral maodel?pls explain with an example?
Can anybody write the test cases for the following scenario. I want to create District. for that, District Code field, District Name field, Reset button, Submit button, Back button are there in the screen. whenever we enter District Code & District Name in the related fields, by clicking on Submit button, District should be created. By clicking on Reset button, all fieds should be cleared. By clicking on Back button, user should navigate to home page. Can you write the test cases for the scenario. I want to know the test case format for the scenario. what procedure is the best. tahnks in advance...
What is quality center? How many built in tables does quality center have?
please send me database stored procedure checklist.