SQL how create select with explicit return values

Question

How do I select like this:

SELECT * FROM
 (SELECT 11 AS Value UNION
 SELECT 24 AS Value UNION
 SELECT 53 AS Value UNION
 SELECT 124 AS Value UNION
 SELECT 2215 AS Value) AS ValueTable

This query give me a perfect result, just this query is ugly.

How create this just nicely such as:

select 11,24...
select arrray(22,24...)

These don't works just examples.

Thx

Answer 1

Your query is correct. The only thing I can do to make it pretty is remove all the field name declaration after the first one

SELECT * 
FROM   (SELECT 11 AS Value  UNION 
        SELECT 24  UNION 
        SELECT 53  UNION 
        SELECT 124 UNION 
        SELECT 2215) AS ValueTable