回答編集履歴

1

where消し忘れ

2018/12/04 09:02

投稿

rururu3
rururu3

スコア5545

test CHANGED
@@ -8,6 +8,6 @@
8
8
 
9
9
  ```php
10
10
 
11
- DB::raw('SUM(CASE cancel_id WHEN 0 THEN 0 ELSE quantity_total END) as cancel_total')->where('cancel_id', '<>', 0)
11
+ DB::raw('SUM(CASE cancel_id WHEN 0 THEN 0 ELSE quantity_total END) as cancel_total')
12
12
 
13
13
  ```