-
To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?
-
- JOIN
- COMBINE
- UNION
- CONCAT
- None of these
Correct Option: C
The ‘UNION’ operator is used for combining the results of various ‘SELECT’ queries into one. For example, ‘SELECT a FROM table1 UNION SELECT a FROM table2;’ produces the results from tables table1 concatenated with that of table2.