wat iz self join write qeriry for table

Answers were Sorted based on User's Feedback



wat iz self join write qeriry for table..

Answer / 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

wat iz self join write qeriry for table..

Answer / srinidhi patil

Joining A table to self is called as self join

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Manual Testing Interview Questions

Can anyone give me the example of High Priority and High severity defect. Please dont give me answers like Spelling mistakes or logo missing something like that. Give me some real time example from your application. Thanks in Advance.

1 Answers   IBM,


What is Stub and Driver ? What functions are used in stubs and driver?

3 Answers   HCL,


If I have written the test cases for any module.And some features are added/removed to & from that module then what should I do with test cases?

1 Answers  


What is network Entry procedure in WIMAX -TEch mahidra question?

3 Answers   Tech Mahindra,


what is the difference between test case and test script?

7 Answers  






What is Retesting & Regression Testing? When do we use retesting & regression testing(i.e In what situation)? Please clear me.

6 Answers  


how to write a test case for check box like in gmail or yahoo

3 Answers   Tech Mahindra,


whar are the contents in db testing test case template

0 Answers   Reliance,


Diff. between system test cases & UAT test cases.

2 Answers   TCS,


What is System Testing Phase? Which types of testing will be conducted in system testing phase?

1 Answers  


who prepares traceability matrix in ur company either jr tester or sr tetser or test lead?

2 Answers   Accenture,


what is black phase in SDLC

4 Answers  


Categories