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

Explain a bug which if you have missed could have created a big problem?

1 Answers   Crea,


what is the difference between agile and spiral model?

1 Answers  


Give proper Seq. to following testing Types Regression, Retesting, Funtional, Sanity and Performance Testing.?

7 Answers   Wipro,


What is a testbed in manual testing?

1 Answers  


Wat type of questions ll be asked in interview for an 1-2 yrs. experinced persond and i need some database concept question in testing.

1 Answers  


Can anybody write the test cases for the following scenario. I want to create District. for that, District Code field, District Name field, Reset button, Submit button, Back button are there in the screen. whenever we enter District Code & District Name in the related fields, by clicking on Submit button, District should be created. By clicking on Reset button, all fieds should be cleared. By clicking on Back button, user should navigate to home page. Can you write the test cases for the scenario. I want to know the test case format for the scenario. what procedure is the best. tahnks in advance...

1 Answers  


what is clinet side validation and server validation??

2 Answers   FIC,


How we make scripts for unit testing with Nunit.

0 Answers  


there is one website i.e google.com.but in our project displayed that goole.com then what is seviority and priority for this scenario

7 Answers  


What is mean by Funtional and Non-Funtional Testing?

3 Answers  


Why do we write test cases?

10 Answers   Synergy,


Hi, dis is Deepa, I completed my Administration Degree, worked as an admin then got promoted and currenting working as an Trainee - Quality Assurance.... I'm not so familiar that job... I would like to do course for Manual testing or Quality Assurance.... Where can i do the course as "the best" Kindly refer me any training centre for this with 100% placement assistance....

4 Answers  


Categories