sql union

SELECT 1 as x
  UNION ALL SELECT 2
  UNION ALL SELECT 2
  UNION ALL SELECT 5
  UNION ALL SELECT 8
  UNION ALL SELECT 10
  UNION ALL SELECT 10;

+----+
| x  |
+----+
|  1 |
|  2 |
|  2 |
|  5 |
|  8 |
| 10 |
| 10 |
+----+
7 rows in set (0.00 sec)