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

回答編集履歴

1

調整

2019/03/18 09:35

投稿

yambejp
yambejp

スコア117923

answer CHANGED
@@ -12,11 +12,12 @@
12
12
  ```
13
13
  - 集計
14
14
  ```SQL
15
- select day
15
+ select coalesce(day,'累計') as day
16
16
  ,sum(price*(user_id=1)) as user_id1
17
17
  ,sum(price*(user_id=2)) as user_id2
18
18
  ,sum(price*(user_id=3)) as user_id3
19
19
  from tbl
20
- group by day with rollup
20
+ group by day with rollup;
21
21
 
22
- ```
22
+ ```
23
+ ※一部調整