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


Please Help Members By Posting Answers For Below Questions

What is the difference between pilot and beta testing?

700


What are the qualities needed by a software tester?

694


wat is test management ?what are the components available in test management?

1597


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

1493


Can you explian $ pillar of Agile

827






What is Pre UAT and UAT is there any difference ?

2976


When new application ready to test than whats your testing strategies?

1242


During alpha testing why customer people are invited?

714


how to verify a button size (e.g Login Button) on a web page have same dimension prescribed by Client in UI Testing..??

1147


Write 2 scenarios for Integration testing? Please let me know its urgent.

1564


How to write test case for view the table(i.e it is already stored in database and see the content in the table)

2043


hi this is satish can some one help me out by sending the maxium notes on client sesrver ,web server and company architechture project hirearchy and company hirearchy i will happy to recive the answers as early as possible

1719


in the account there is 10,000 rupees and i entered 20000, in this case how will you test the application

1255


Give me sample test cases for smoke testing

8677


Is an "A fast database retrieval rate" a testable requirement?

1521