What is difference between Inner vs Self vs Cross?
Posted On: Feb 22, 2018
Inner Join: Inner Join can also be called the simple join. It allows the coder to filter the outcomes of the cartesian product by some predicate.
Self Join: It is used to join one single table with itself as there were two different tables.
Cross Join: This is the basic join, it is nothing but a cartesian product. This join method compares every single row of a table with every single row of the other table.
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
Appinventiv Php Developer Interview Questions
How to find datatype of variable in PHP?
You can find the datatype of a variable in PHP by using the Var_dump() and gettype() functions....
Appinventiv Php Developer Interview Questions
Difference between get and post method.
Some differences are:..
Appinventiv Php Developer Interview Questions
What is Interface? Why it is used?
An interface can be defined as a platform that permits users to develop programs that mention all public methods that need to be implemented by various classes. It does not involve any complexity or d...