[Redshift][PostgreSQL] WITHå¥ã‚’使ã£ã¦SQLをシンプルã«ã€‚ | DevelopersIO環境 MAC OSX 10.10.5 Yosemite 使ã„方（例） テーブルã®æº–å‚™ CREATE TABLE items ( id SMALLINT , name VARCHAR(16) , item_id SMALLINT , item_name VARCHAR(16) , PRIMARY KEY(id, item_id) ); INSERT INTO items VALUES (1, '文房具', 1, 'シャーペン') , (1, '文房具', 2, '消ã—ゴム') , (1, '文房具', 3, '定è¦') , (2, 'ã‹ã°ã‚“', 1, 'リュックサック') , (2, 'ã‹ã°ã‚“', 2, 'ショルダーãƒãƒƒã‚°'); CREATE TABLE genre ( id SMALLINT , name VARCHAR(16) ,PRIMARY KEY(id) ); # SELECT *
![[Redshift][PostgreSQL] WITHå¥ã‚’使ã£ã¦SQLをシンプルã«ã€‚ | DevelopersIO](https://cdn-ak-scissors.b.st-hatena.com/image/square/28da6328f8613d3f22dab21ae3790ab0f72d2e3d/height=288;version=1;width=512/https%3A%2F%2Fimages.ctfassets.net%2Fct0aopd36mqt%2F1dD7b8HkT2sbiJzUIewMTD%2Fe5cdc6f33c4fdd9d798f11a4564612ff%2Feyecatch_developersio_darktone_1200x630.jpg)
{{#tags}}- {{label}}
{{/tags}}