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

What is early testing?

671


3.if a questions asked as,what is the quality standards you are following? what i need to tell.

1361


Explain thread testing.

659


When did u complete testing ? Which scenrio should not be in automation testing ? why ?

2391


What is the negative testing and example

988






Why you are selected software testing as career ?

865


1. what exactly is heuristic checklist approach for unit testing ?

2214


What do you understand by usability testing?

654


which domain is of high demand for software testing, Right now i am working in Education domain .How about demand for Education domain and which companies are recruiting in education domain

3212


Hi Frnds, this is Aman.. can anybody tell me plz what kind of QA Interview questions are asked by IDS Infotech Ltd., Chandigarh? I have lil bit experience only in Manual Testing.. Plz answer my question as soon as possible.. Thnx in advance..

1908


What is an exit criteria?

662


What is bucket testing?

656


What are the main key components in Web applications and Client Server applications? and their differences?

1489


Can you explain calibration?

656


Testcases for msword( microsoct office word??

1664