Interested to Buy Any Domain ? << Click Here >> for more details...
What different of iner joint & outer joint with example
- 4 Answers
- 9973 Views
- I also Faced
- E-Mail Answers
Answer Posted / tripti gour
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 |
Post New Answer View All Answers
What is oracle server autotrace in oracle?
Is oracle a relational database?
How to create additional tablespaces for an new database?
How to convert characters to numbers in oracle?
Explain the function of optimizer in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How much memory your 10g xe server is using?
What is redo log?
What is a select query statement in oracle?
Explain the truncate in oracle?
How to establish administrator authentication to the server?
Explain the types of exception?
What are the differences between lov and list item?
How to retrieve the count of updated rows?
defination of bitmap index
