Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / Tarun Raj
1. INNER JOIN: Returns only records that have matching values in both tables. The result set includes columns from both tables, and there are no NULL values for the matched columns.
2. LEFT JOIN (also called LEFT OUTER JOIN): Returns all records from the left table (the first table in the join statement), and the matched records from the right table. If there is no match, the result set will contain NULL values on the side of the right table.
3. RIGHT JOIN (also called RIGHT OUTER JOIN): Returns all records from the right table (the second table in the join statement), and the matched records from the left table. If there is no match, the result set will contain NULL values on the side of the left table.
4. FULL OUTER JOIN: Returns all records when there is a match in either the left or right table. The result set includes NULL values for the unmatched columns.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
define sql insert statement ? : Sql dba
Is primary key clustered index?
what is schema? : Sql dba
How do I remove duplicates in two columns?
What is the current version of postgresql?
how to escape special characters in sql statements? : Sql dba
what are all the common sql function? : Sql dba
What is the best sql course?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Do we need to rebuild index after truncate?
Can we rollback truncate?
what is collation? : Sql dba
Can we use distinct and group by together?
Does group by remove duplicates?
What is the current version of sql?
