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.
Loading...
Related Quiz
- To get the list of all supported filters in PHP, you can use the filter_list() ______.
- How can you retrieve the last inserted ID after inserting a record into a MySQL table using PDO?
- In PHP, what is the purpose of the $this keyword?
- What is the PHP function to sanitize a string?
- Which of the following are true about PHP data types?