Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join?Explain the different types of joins?
- 6 Answers
- 33640 Views
- Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / sheels
Join is used to combin rows from multiple table. Join is performed when ever two or more table is listed in the FROM clause of an SQL statment.
Types of Join;
1.Natural Join: Natural join tells the database to join two table using the common columns.
2.Equality Join: Here the table is related using the equal(=) sign.
3.Inner Join: This is the most common type of join. Inner join returns all the rows from the table when the join condition is met.
4.Outer Join:It joins the matching records from two table and all the records from one side of the table and those un matching records have null value.
(i)Left Outer Join:It joins the matching records from two table and all the records from left side of the table and those unmatching records have null value.
(ii)Right Outer Join: It joins the matching records from two table and all the records from right side of the table and those unmatching records will have null value
5.Self Join: It is used to join a table to it.
| Is This Answer Correct ? | 26 Yes | 0 No |
Post New Answer View All Answers
Can we alter stored procedure?
What are literals in sql server?
how can we submit a form without a submit button? : Sql dba
what are the authentication modes in sql server? How can it be changed? : Sql dba
what is the functionality of the function htmlentities? : Sql dba
What is sequence in sql?
what is bcp? When does it used? : Sql dba
Which is faster truncate or drop?
what is the difference between myisam static and myisam dynamic? : Sql dba
What is the difference between stored procedure and view?
What is blind sql injection?
Why do we use joins in sql?
How many types of index are there?
What is the current version of postgresql?
What is sqlca in db2?
