回答編集履歴

2

ごじしゅうせい

2018/02/07 17:53

投稿

wasi300
wasi300

スコア66

test CHANGED
@@ -12,7 +12,7 @@
12
12
 
13
13
  COUNT(CASE WHEN table.kb = 0 THEN table.kb END) as a_kb
14
14
 
15
- COUNT(CASE WHEN table.kb = 0 THEN table.kb END) as b_kb
15
+ COUNT(CASE WHEN table.kb = 1 THEN table.kb END) as b_kb
16
16
 
17
17
  from table
18
18
 

1

リンク

2018/02/07 17:53

投稿

wasi300
wasi300

スコア66

test CHANGED
@@ -20,4 +20,4 @@
20
20
 
21
21
 
22
22
 
23
- https://qiita.com/suisuina/items/b0961d55bc1d9bd2a8ed
23
+ ### https://qiita.com/suisuina/items/b0961d55bc1d9bd2a8ed