Interested to Buy Any Domain ? << Click Here >> for more details...
What different of iner joint & outer joint with example
- 4 Answers
- 10230 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / joel
inner join will select the record that are match only. it is
just like equi join. but outer join select the record not
only the equal one but also select the not equal one.
outer join is of three type namely
right outer,
left outer and
full outer.
1) right outer join will be like below in the join condition
e.deptno(+)=d.deptno.
that is it select all the uncommon values including common
values from the table e.
2)while left outer join will be like below in the join condition
e.deptno=d.deptno(+);
it will select uncommon values including common values
from table d.
3) full outer join is as like inner join. it will select
common values only
| Is This Answer Correct ? | 14 Yes | 6 No |
Answer / nusrath sultana
Inner join:fetch the data when matched,similar to equi join.
Outer join:fetch the data matched as well as some unmatched
data.
there are three types of outer join :
1)left outer join:it will fetch the data when matches in two
or more relation and the unmatched data from the left
relation is also selected.
SQL>SELECT E.ENAME,E1.COMM FROM EMP E LEFT OUTER JOIN EMP E1
ON E.EMPNO=E1.EMPNO;
2)right outer join:it will fetch the data when matches in
two or more relation and the unmatched data from the right
relation also selected.
SQL>SELECT E.ENAME,E1.COMM FROM EMP E RIGHT OUTER JOIN EMP
E1 ON E.EMPNO=E1.EMPNO;
3)full outer join:it will fetch the data when matches in two
or more relation and the unmatched data from the BOTH
relations are also selected.
SQL>SELECT E.ENAME,E1.COMM FROM EMP E FULL OUTER JOIN EMP E1
ON E.EMPNO=E1.EMPNO;
| Is This Answer Correct ? | 1 Yes | 0 No |
INNER JOIN: inner join fetch only matched data from 2 or
more tables.
ex: select empno, ename, e1.deptno, d1.deptno, dname
from emp e1, dept d1
where e1.deptno = d1.deptno;
output will the all records whose deptno is exists in both
table (emp and dept)
OUTER JOIN: is used to fetched matched and unmatched data
from 2 or more tables.there are 3 type of outer join:
Right outer join , Left outer join, Full outer join.
Right outer join will display the matched and unmatched
records of right side located table.and Left outer join does
just opposite of it.and Full outer join will display matched
and unmatched both type of records from both tables.
ex: select empno, ename, e1.deptno, d1.deptno, dname
from emp e1 right outer join dept d1
on e1.deptno =d1.deptno;
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / rizwan khan
inner Join used for Display All Match Data From two or
multible table.
Outer Join :- Display All unmached data.
| Is This Answer Correct ? | 4 Yes | 8 No |
if you update view? where we store the data?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
what are the disadvantages of hierarchial database over RDBMS?
What is the difference between postgresql and oracle?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
How to invoke the data pump import utility?
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
Define Normalization with example?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Who i will insert 1 lacks record in a Database table
Can u make a synonym for deptno=10 only from emp table.
What is tns service name?
Oracle General 
