What is a join?Explain the different types of joins?
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
What is keys and its types?
What is the largest value that can be stored in a byte data field?
Is inner join faster than left join?
What mean sql?
Where do we use pl sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
what is data manipulation language? : Sql dba
Does mysql_real_escape_string prevent sql injection?
What is the difference between in and between in sql?
What is the difference between instead of trigger and after trigger?
What are the two virtual tables available at the time of database trigger execution?
What is the difference between a database and a relational database?
What are different functions in sql?
What are the set operators in sql?
How many aggregate functions are available there in sql?