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 vote144 views2 answers
Greater than sql server
SQL
0 vote145 views1 answer
Porcentaje sql
SQL
0 vote135 views4 answers
Restart MySQL
SQL
9 votes166 views3 answers
Date format in sql
SQL
1 vote133 views1 answer
Where date = max(date) in sql
SQL
0 vote134 views1 answer
Sql date d'aujourd'hui
SQL
0 vote147 views1 answer
Mysql changer nom table
SQL
0 vote156 views1 answer
Hierarchal database table
SQL
8 votes144 views1 answer
Oracle tablespace datafile max size
SQL
0 vote134 views1 answer
Laravel general error 2006 mysql server has gone away
SQL