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 frame level testing and how do we test it?

1974


what is localization and globalization.and what are the ways way are going to test the particular application?how can we identify factual, visual, corrupted characters, link errors, formatting errors, etc in locallization?iam going to attend the interview on localization concepts and languages like : German, Japanese, French, Russian, Italian, Chinese, Korean, Portuguese and Spanish .tell me the process how to do testing above concepts let me know its urgent:anilaluvala@gmail.com 9908814046

1602


Differentiate test bed and test environment?

2123


1. what is a date guidelines ?

1665


Describe any bug you remember. Plz Give some real examples

1651






what is coupling integration testing

1640


How can I use bugzilla in my company to track a bug and to allow the client to see the bug report online throughbugzilla. Please explain in detail. I am really need this.

2636


what is the common in all s.o.p (standaed operating procedure)?

1514


what is metrics in software testing? give me a brief detail about it?

4172


Please send any one latest 3+ years of experience testing tools resumes my mail id is krishnavenimodaliar26@gmail.com

2885


what are the risk factors in the project? what is the base for testplan and entry criteria ,exit criteria for test plan?

1953


Negatives test cases of gmail login page With its severity , priority and expected results columns Through test case template-oodles technologies gurgoan

2187


iam having 2+yr sof exp in manual testing, at present working in chennai,want to relocte to hyd .if any openings let me know.my id : vaniramymail.com

1633


What is date driven testing?

690


Iam new to testing field and i put lot of experiences so i want to get prepared for the interview in all the ways both in manual and Automation can any one help me how to answer there questions in real time. also can anyone send the top questions and answers to me plz its urget u can mail me at vaisu72@yahoo.com

1469