Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 are the roles of glass-box and black-box testing tools?

2075


HI can i know who is taking real time testing classes in banglore? i am preparing to put 3+year experience in testing if possible anybody give suggestions for preparing 3+exp

1909


What is back to back testing?

1974


Hi there, I am new to the world of testing. Is there any place where I can have a look at an actual specification documents or test plans or test cases. This will help me in generating a level of confidence. Looking forward to your replies

1922


what r the measure bugs found in your project??? Give some example abt this.

4881


what are all the things we will include in " what to be tested and what not to be tested" in Test Plan

2057


When have you had to focus on data integrity?

2586


how will you test transfer funds module...explain in detail

1559


What are testing techniques? What is difference between general and specific?

2149


What are the basic forms of variations?

2200


What is the different between SIT and UIT?

1403


what is the main field of bugzilla which we fill to report bug to any developers???give some brief description??

2020


What is test startegy?

1188


Why Equivalence Partitioning is called equivalence or what is the significance of equivalence term in ECP?

2067


Could some one tell me test cases for multi line text boxes like Notes field?

2125