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...

wat iz self join write qeriry for table

Answer Posted / manish

Sometimes you need to join a table to itself. To find the
name of each employee’s manager, you need to join the
EMPLOYEES table to itself, or perform a self join.

The Query:

SELECT worker.last_name || works for || manager.last_name
FROM emp worker, emp manager
Where worker.emp_id = manager.emp_id;

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write a set of test cases to test youtube?

7728


.In languages testing, what is the fixed part and changing part?

2164


what is agile model and spiral maodel?pls explain with an example?

2721


Explain severity with example and expalin each example?

4420


whats main working for tester. and developer, and prject manager.

2226


any one giv test cases for wordpad using equivalence class partioning

3152


Easiest way to write test cases? How i can learn writing the test cases?

1492


What is junit & api?

2362


Which test cases are written first: white boxes or black boxes?

1323


Hi Dear this urgent for me i have need of ROLTA India Ltd Mumbai Paper pattern for Testing Person , PLease Help me , if any body have any idea about it

4077


What is build interval period?

2370


Test cases on send/ receive button of Microsoft outlook.

4670


How to write testcases for unread/read mails for gamil inbox? and what are the types of testing you do on them?

4576


Explain branch coverage and decision coverage.

1151


Can anybody help i put the pharma and bank project in my resume, but i dont know what to tell about them, any body tell the where can i get the information about them,what i need to tell about these applications,please help me

2166