Skip to content

Instantly share code, notes, and snippets.

@doryokujin
Last active July 3, 2017 06:04
Show Gist options
  • Save doryokujin/493c2e636d1fd66924b55745c1aa55f9 to your computer and use it in GitHub Desktop.
Save doryokujin/493c2e636d1fd66924b55745c1aa55f9 to your computer and use it in GitHub Desktop.
SELECT * FROM (VALUES (1, 'apple'), (2, 'banana')) as fruit(id, name);
# このクエリでは, 以下のデータセットがクエリ内で生成され使用されています。
# id | name
#-----+--------
# 1 | apple
# 2 | banana
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment