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.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *