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

One very small question, If application/ website performing all the function perfectly like submission, deletion, editing etc, why do we require Data base testing saparately. Please understand before reply thanks !!

3 Answers   Adobe,


Hi friends This is sowmya plz can u tell me what type of questions will they ask in banking domain in interview plz let me know thanks in advance

1 Answers   CTS,


I need a Test case templetes for Yahoo Mail ID

1 Answers  


Expain testing proces of your company?

6 Answers   AppLabs,


How do you manage your writen/modified/executed test cases, Bug report etc,without using any tool?

1 Answers  






what r the different types of testing techniques?

9 Answers  


what are the do's and dont's of a tester?

1 Answers  


What is a traceability matrix, and what is the purpose of it?

11 Answers   Apex, Matrix,


what is the structure of test cases

3 Answers  


What is Test Suite?

11 Answers   Digient Technologies,


What is the initial stage of testing?

3 Answers  


as a tester, do u know only ur module requirements or other module req's also?

4 Answers   Accenture,


Categories