In a LEFT JOIN operation, which table's data is retained even if there are no matching rows in the other table?
- Both tables
- Left table
- Neither table
- Right table
In a LEFT JOIN, the data from the left table (first table in the JOIN statement) is retained, even if there are no matching rows in the right table. This ensures that all rows from the left table are included in the result set.
Loading...
Related Quiz
- Scenario: A company's database performance is degrading due to a large volume of data. How can partitioning help improve performance in this scenario?
- What is the primary function of a cursor in DB2?
- In DB2, what does a view represent?
- What role does the buffer pool play in DB2's architecture?
- Which SQL statement is used to create a user-defined function in DB2?