What is the difference between left and right outer join?
devquora
Posted On: Jan 09, 2021
The difference between the left and right outer join is as follows:
| S. N. | Left Join | Outer Join |
|---|---|---|
| 1 | A left outer join provides the table in the FROM clause whose all rows are returned. | A right outer join allows for returning all rows from the table specified in the join clause. |
| 2 | A left outer join fetches the unmatched rows from the table which is on the left of the join clause. | A Right outer join fetches the unmatched rows from the table which is on the right of the join clause. |
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
NIIT Technologies Java Interview Questions
What is abstraction?
Abstraction is basically used to separate the useless data from the essential ones. Only the important things that need to be shown to the users are only being exposed. Here in these issues, the users...
NIIT Technologies Java Interview Questions
Explain how HashMap works?
HashMap in Java works on hashing principles. Hashing is a process in which hash functions are used to link key and value in HashMap....
NIIT Technologies Java Interview Questions
Write a factorial program using recursion in Java?
A factorial program using recursion in JAVA is as follows: class FactorialExample2{ static int factorial(int n){ if (n == 0) return 1; else return(n * factorial(n-...