He has given table attributes-
empid,empfirstname,emplastname,MangerID.And he asked write
query to display empfirstname and mangername?

Answer Posted / naveen kamatam

select a.employee_id,a.first_name,a.manager_id,b.first_name
from test a inner join test b
on a.manager_id=b.employee_id order by 1

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain accessibility testing and its importance in the present scenario.

685


What’s the difference between verification and validation in testing?

638


What is bug severity?

657


Can you do system testing at any stage of sdlc?

665


What's the difference between system testing and acceptance testing?

726






What is strategy to be followed for execution of 500 Test Cases in One day. If only 1 Resource is available.

1489


What criteria would you use to select Web transactions for load testing?

1653


hai friends i did my bcom (distance with out inter)and iam pursuing mca(distance alagappa university)iam learning testing cource in ameerpet can i elgibel for testing jobs pls guide me … …and send details to rangavijetha@gmail.com..thanks

1356


If there is non reproducible bug which developer is not ready to agree, how you will convince him.

7631


Inwhat basis the time is allocated for testing the application?

1425


What are the cases when you’ll consider to choose automated testing over manual testing?

629


Can you explain an application boundary?

650


Write the function test case to add a customer to database.

1715


What is the difference between baseline and traceability matrix?

733


1.what promted you to become involved in QA/Testing?

1743