Database Analyst Question:
Download Job Interview Questions and Answers PDF
Tell me what is the difference between LEFT JOIN and RIGHT JOIN?
Answer:
A LEFT JOIN returns all records from the left table, even when they do not match in the right table. Missing values become NULL. In a similar manner, a RIGHT JOIN returns all records from the right table, even when they do not match those in the left table. Missing values become NULL.
Download Database Analyst Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell us what is involved in typical data analysis? | Tell us what are the important steps in data validation process? |