Which type of join returns only the rows that have matching values in both tables?
- Inner Join
- Left Join
- Outer Join
- Right Join
Inner Join returns only the rows that have matching values in both tables based on the specified join condition. Other types of joins may return unmatched rows as well.
Loading...
Related Quiz
- How do different editions of DB2 cater to varying enterprise needs?
- Which utility is commonly used for database backup and recovery tasks in DB2?
- How does DB2 integrate with other technologies?
- To determine if an index is being used by the query optimizer in DB2, you can analyze the ________.
- In disaster recovery planning, what does the term "RPO" stand for?