For that you can use self join. With in organization you will get manager

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

Question Posted / nandini p

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

Please Help Members By Posting Answers For Below Questions

What are the cases why parameterization is necessary when load testing the Web server and the database server?

2120

need testing projects where can i find them

2254

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

2167

How does quality control differ from quality assurance?

1137

What makes a good software qa engineer?

1192

What is build interval period?

2401

What does a manual tester need to become proficient with db testing?

1217

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

2011

What is formal testing?

1207

What is Test Design?

2231

What is the difference between authentication and authorization in web testing?

1336

can anybody tell me what is release process of company? release note?

1986

Suggest some book to learn more test case???

2092

Hi All I want discuss abt Testing tools is any one available online in google chat?

2149

Explain severity with example and expalin each example?

4493