self join query in sql.
15 objective questions.
What is equi join and outer join

Answers were Sorted based on User's Feedback



self join query in sql. 15 objective questions. What is equi join and outer join..

Answer / swaroopa

What is Equi Join and Outer Join ?

Equi Joins are also called Simple Joins or Inner Joins.
An equi-join is a join based on equality or matching
between the column values for two different tables.

This equality is indicated with an equal sign (=) as the
comparison operator in the WHERE clause

Ex:SELECT * FROM manufact, stock
WHERE manufact.manu_code = stock.manu_code

manufact and stock are the tables on the manu_code column.
It retrieves only those rows for which the values of the
two columns are equal.

Outer Join:

OUTER JOIN is used to join two tables even if there is not
a match. The joined table retains each record—even if no
other matching record exists. Outer joins subdivide further
into left outer joins, right outer joins, and full outer
joins, depending on which table(s) one retains the rows
from (left, right, or both).

Is This Answer Correct ?    7 Yes 0 No

self join query in sql. 15 objective questions. What is equi join and outer join..

Answer / latha

self join:one physical table is divided into two logical tables and perform join operation on that tables.
query:
select a.eno,a.ename,b.ename as manager name from emp a,emp b where a.manager num=b.eno
equi join:perform join operations on matching columns on both the tables

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Manual Testing Interview Questions

How does one do Regression Testing for Manual Testing projects?

4 Answers  


1 what is smoke and sanity testing , when it will be performed ?

3 Answers  


How do we decide that testcases covers all the requirements?

1 Answers   Crea,


Which are the basic challanges are face tester while doing testing?

2 Answers  


Explain user acceptance testing.

0 Answers  


can any body explain about BVA and ECP briefly?

3 Answers  


equivalence class partitioning techniques used in system testing or not

1 Answers   iSoft,


What is meant by Entry and Exit points in Testing? Raam - ramumcato@yahoo.com

7 Answers   Ness Technologies,


Differences between waterfall and V model

1 Answers   ADP,


diff b/w alpha & beta testing? who will do this with examples? can u pls help in this topics

3 Answers  


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

6 Answers  


Wells Fargo Testing interview If we are told to perform only regression testing on a software application and not to do sanity testing , then what could be the nature of your software application.

1 Answers   Wells Fargo,


Categories