Union the subquery : Union « Select Clause « SQL / MySQL

1. SQL / MySQL
2. Select Clause
3. Union

Union the subquery

   
mysql>
mysql>
mysql> SELECT   *
    -> FROM    (SELECT 'Stratford' AS TOWN, 4 AS NUMBER
    ->          UNION
    ->          SELECT 'Plymouth', 6
    ->          UNION
    ->          SELECT 'Inglewood', 1
    ->          UNION
    ->          SELECT 'Douglas', 2) AS TOWNS
    -> ORDER BY TOWN;
+-----------+--------+
| TOWN      | NUMBER |
+-----------+--------+
| Douglas   |      2 |
| Inglewood |      1 |
| Plymouth  |      6 |
| Stratford |      4 |
+-----------+--------+
4 rows in set (0.00 sec)

mysql>
mysql>

   
    
    
  

Related examples in the same category