回答率: 85.31%

質問するログイン新規登録

トップ SQLに関する質問 SQL　縦持ちを横持ちへ（ド素人です）

編集履歴

回答編集履歴

1

SQLが誤っていたので修正

2021/04/06 16:16

投稿

neko_the_shadow

スコア2374

test CHANGED Viewed

@@ -8,9 +8,9 @@
   employee_id,
-  MAX(CASE WHEN RANK = 1 THEN role_id END) AS role1,
+  MAX(CASE WHEN rnk = 1 THEN role_id END) AS role1,
-  MAX(CASE WHEN RANK = 2 THEN role_id END) AS role2
+  MAX(CASE WHEN rnk = 2 THEN role_id END) AS role2
 FROM (
@@ -18,7 +18,7 @@
     *,
-    RANK() OVER (PARTITION BY employee_id ORDER BY role_id) AS rank
+    ROW_NUMBER() OVER (PARTITION BY employee_id ORDER BY role_id) AS rnk
   FROM employee