Answer Posted / Anusha Sachan
A LEFT JOIN retrieves records from both tables in the join operation, but returns all records from the table on the left and matching records (if any) from the table on the right. If there are no matches for the right table, NULL values will be returned for those columns.
| 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
Can delete statement be rollbacked?
What is the current version of postgresql?
Do we need to rebuild index after truncate?
Is inner join faster than left join?
Is primary key always clustered index?
what are all the common sql function? : Sql dba
Can we use distinct and group by together?
how to start mysql server? : Sql dba
how to escape special characters in sql statements? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
Is primary key clustered index?
how to use regular expression in pattern match conditions? : Sql dba
Does group by remove duplicates?
what is collation? : Sql dba
