Which type of SQL clause is used to combine rows from two or more tables based on a related column?
- GROUP BY clause
- JOIN clause
- ORDER BY clause
- WHERE clause
The JOIN clause in SQL is specifically designed to combine rows from two or more tables based on a related column. It allows you to fetch related data from multiple tables in a single query, making it a fundamental aspect of database querying and analysis.
Loading...
Related Quiz
- What is the difference between blind SQL injection and classic SQL injection?
- What is the purpose of the SQL JOIN clause in database queries?
- In data migration testing, what is the role of a data mapping document?
- In incremental data migration, only the ____________ data is migrated to the target system.
- What is the main reason for conducting database testing?