To combine the result set of two or more SELECT statements, one can use the SQL ________ operator.

  • JOIN
  • UNION
  • FROM
  • INTERSECT
To combine the result set of two or more SELECT statements, you can use the 'UNION' operator in SQL. It retrieves all distinct rows from the combined queries, effectively merging the result sets. 'JOIN' combines rows from multiple tables, 'FROM' specifies data sources, and 'INTERSECT' returns common rows between queries.
Add your answer
Loading...

Leave a comment

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