SQL SELECT Statische Werte
| ID | 245 |
|---|---|
| Link Reference | Not set |
| Link Credits | Not set |
| Link Technical Documentation | Not set |
| PlCodelang | PL/pgSQL |
| PlGroup | Datenbank |
| PlItemTitle | SQL SELECT Statische Werte |
| Code | SELECT * FROM ( VALUES (1, 2), (3, 4) ) AS q (col1, col2) ; -- the same as: SELECT 1 AS col1, 2 AS col2 UNION ALL SELECT 3 AS col1, 4 AS col2 ; -- col1 | col2 -- =========== -- 1 | 2 -- ----------- -- 3 | 4 |
| Result Example |