What does a JOIN operation in SQL do?
- Combines rows from two or more tables based on a related column between them.
- Deletes duplicate rows from a table.
- Inserts new rows into a table.
- Sorts the table in ascending order.
JOIN operations in SQL are used to combine rows from two or more tables based on a related column, typically using conditions specified in the ON clause. This allows you to retrieve data from multiple tables in a single result set.
Loading...
Related Quiz
- Which SQL clause is used to filter records based on more than one condition?
- When would you use a pie chart in data visualization?
- The use of _______ scales in maps can significantly alter the perceived message of the visualized data.
- What is a primary function of BI tools like Tableau and Power BI in data analysis?
- A _________ chart is a visual representation of project tasks along a timeline, commonly used in project planning.