Home » MYSQL » MySQL UNION » Question
  1. To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?
    1. JOIN
    2. COMBINE
    3. UNION
    4. CONCAT
    5. 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.



Your comments will be displayed only after manual approval.