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

Hi could some one please send me the testplan testcases(for 2Modules) and testscripts for mercry fliht aplication or gmail. please write those on templates and send me.In testplan plase write Testobjective, test scope, est approach, exlusions assumptios.

1563


how will the test plan is pepared in ur organisation>?

1492


How would you do the ollowing Security Testing for web application? 1) Authentication. 2) Authorization. 3) cookies. 4) penetration testing. 5) session testing. 6) encryption and decryption testing pls give examples give example i can't understand so pl

2040


Suggest some book to learn more test case???

1354


uses of checklist

1516






Enlist some bug status along with its description?

723


How to find that tools work well with your existing system?

1594


What are the benefits of requirement traceability?

660


HOW TO CREATE SRS REVIEW REPORT TO PL?

1904


what is functional testing terminologies

1911


If you're given a program that will average student grades, what kinds of inputs would you use?

4410


Can you explain the pdca cycle and where testing fits in?

773


Encapsulation of attributes and operations inside objects makes it easy to obtain object state information during testing. is it true.explain

1642


What r the documents required for performance testing

1810


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

7613