Answer Posted / Siddhartha Kumar Prasad
Use INNER JOIN when you want to find matching records between two tables. Use LEFT JOIN when you want to retrieve all records from the left table, including those with no match in the right table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to use regular expression in pattern match conditions? : Sql dba
what is dbms? : Sql dba
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 we rollback truncate?
what are all the common sql function? : Sql dba
Do we need to rebuild index after truncate?
Is inner join faster than left join?
define sql insert statement ? : Sql dba
What is the current version of postgresql?
what is sql server agent? : Sql dba
Can delete statement be rollbacked?
how to escape special characters in sql statements? : Sql dba
Can we use distinct and group by together?
What is the best sql course?
If a cursor is open, how can we find in a pl/sql block?
