回答編集履歴
2
ごじしゅうせい
answer
CHANGED
|
@@ -5,7 +5,7 @@
|
|
|
5
5
|
SELECT
|
|
6
6
|
MAX(key_no),
|
|
7
7
|
COUNT(CASE WHEN table.kb = 0 THEN table.kb END) as a_kb
|
|
8
|
-
COUNT(CASE WHEN table.kb =
|
|
8
|
+
COUNT(CASE WHEN table.kb = 1 THEN table.kb END) as b_kb
|
|
9
9
|
from table
|
|
10
10
|
```
|
|
11
11
|
|
1
リンク
answer
CHANGED
|
@@ -9,4 +9,4 @@
|
|
|
9
9
|
from table
|
|
10
10
|
```
|
|
11
11
|
|
|
12
|
-
https://qiita.com/suisuina/items/b0961d55bc1d9bd2a8ed
|
|
12
|
+
### https://qiita.com/suisuina/items/b0961d55bc1d9bd2a8ed
|