minte9
SoftwareDevelopment / MYSQL





Combine the result

Combine the result from multiple SELECT statements into a single result set. 
 
SELECT 10 AS a
UNION 
SELECT 20;

| a |
*--
10
20

Example 

 
SELECT City FROM Customers
UNION
SELECT City FROM Suppliers
ORDER BY City;
https://www.w3schools.com/sql/sql_union.asp



Questions and answers:
Clink on Option to Answer




1. Which UNION is correct

  • a) SELECT a, b FROM page UNION SELECT c
  • b) SELECT a, b FROM page UNION SELECT c, d


References: