Discussion
Which SQL join returns all rows from both tables, with NULL values for non-matching rows ?
Answer: D
The join is the FULL OUTER JOIN.
A full outer join returns every matched row plus the unmatched rows from both tables, filling the missing side's columns with NULL. It is in effect the union of a left and a right outer join.
An INNER JOIN returns only matching rows. A LEFT JOIN keeps all rows of the left table, with NULLs for unmatched right-hand columns, and a RIGHT JOIN does the same for the right table. Each of them keeps the unmatched rows of one table only.
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development