Answer Posted / Bhupender Prajapati
There are four main types of joins in SQL: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN. An INNER JOIN returns only the common rows between two tables; a LEFT OUTER JOIN displays all rows from the left table and matching rows from the right table; a RIGHT OUTER JOIN shows all rows from the right table and matching rows from the left table; a FULL OUTER JOIN displays all rows when there is a match in either the left or right table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
what is collation? : Sql dba
define sql insert statement ? : Sql dba
How do I remove duplicates in two columns?
Is inner join faster than left join?
What is the current version of postgresql?
Is primary key clustered index?
Can we rollback truncate?
Do we need to rebuild index after truncate?
What is the current version of sql?
what are all the common sql function? : Sql dba
What is your daily office routine?
how to start mysql server? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
what is bcp? When does it used? : Sql dba
