回答編集履歴
1
訂正
answer
CHANGED
|
@@ -6,5 +6,5 @@
|
|
|
6
6
|
(SELECT 部コード,1 AS D ,0 AS J,1 AS G FROM 部登録テーブル WHERE 性別コード = 1
|
|
7
7
|
UNION ALL
|
|
8
8
|
SELECT 部コード,0,1,1 FROM 部登録テーブル WHERE 性別コード = 2
|
|
9
|
-
) TB GROUP BY 1
|
|
9
|
+
) TB GROUP BY 1 ORDER BY 1
|
|
10
10
|
```
|