Select without FROM but with more than one rows

Question

How can I produce a table with 2 rows and 2 columns without selecting from an existing table? What I'm looking for is a select statement that returns, e.g. ``` id | value --------- 1 | 103 2 | 556 ```

Accepted Answer

Use `UNION`

```
SELECT 1 as id, 103 as value
UNION
SELECT 2 as id, 556 as value
```

See this SQLFiddle

Select without FROM but with more than one rows

Solution

Problem