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

1 vote219 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote207 views1 answer
Mysql exception output
SQL
0 vote211 views2 answers
Plsql function that return a table
SQL
11 votes259 views2 answers
You are using safe update mode
SQL
0 vote229 views1 answer
How to retrive the today date sql
SQL
8 votes204 views1 answer
Oracle create datafile
SQL
10 votes317 views4 answers
Sql server pagination
SQL
0 vote188 views1 answer
Show specific events on mysql
SQL
1 vote169 views1 answer
Oracle boolean to varchar
SQL
3 votes291 views2 answers
How to modify rows in SQL Server
SQL