Postgres select from values

=> SELECT * FROM (VALUES (1, 'one'), (2, 'two'), (3, 'three')) AS t (num,letter);
 num | letter
-----+--------
   1 | one
   2 | two
   3 | three
(3 rows)

Source: postgresql.org

Similar codes

0 vote143 views1 answer
Grant access on table in oracle
SQL
0 vote138 views1 answer
Database xml sql
SQL
0 vote100 views1 answer
Mysql find foreign key references
SQL
0 vote146 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
-1 vote145 views3 answers
Psql get last rows
SQL
0 vote150 views1 answer
How to locate pg_hba.conf file
SQL
0 vote164 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote146 views1 answer
Mysql date time string format for marshmellow field schema
SQL
0 vote150 views1 answer
Get date ISO in psql
SQL
7 votes222 views1 answer
Oracle alter sequence restart start with
SQL