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.
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

tell me 4 test case technics ?

3 Answers  

what is exactly a tracebility matrix?

11 Answers   Patni, TCS,

What is Change and configuration management repositoty

1 Answers   Sierra Atlantica,

give me atleast 10 cases for GOOGLE search engine?

1 Answers  

What is the difference between quality assurance and quality control?

4 Answers   Crea,

Explain about Defect Leakage?

1 Answers   HCL,

I am doing manual testing for one website application. already i had prepared test case report,bug tracking report. now i need to perform functional testing of the application and prepare function test report. so can u send one model of the functional test report to me.. it is very helpful to me. my id is

0 Answers   SoftSquare,

When we use Comparison Testing ?

2 Answers   Crea,

The company is developing a new piece of software. The application allows a computer user to use the print option of any existing application to save the output into an HTML file instead of printing. -Based on the scenario above, which test methods do you use to make certain that the new software will work properly with existing applications?

1 Answers  

Realizing you won't be able to test everything - how do you decide what to test first?

4 Answers  

What are the Important test scenarios which can be used for testing a web site?

0 Answers   Infogain,

How should validation activities be handled?

0 Answers