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

回答編集履歴

1

調整

2019/10/15 09:33

投稿

yambejp
yambejp

スコア117946

answer CHANGED
@@ -11,7 +11,7 @@
11
11
  (5,'2020-01-03',4,10000);
12
12
  ```
13
13
  - 集計
14
- ```
14
+ ```SQL
15
15
  select t1.id,t2.date,t1.complete,t2.profit from (
16
16
  select id,sum(complete) as complete,sum(profit) as profit
17
17
  from report
@@ -20,4 +20,12 @@
20
20
  with rollup
21
21
  ) as t1
22
22
  left join report as t2 using(id)
23
+ ```
24
+
25
+ - union allするなら
26
+ ```SQL
27
+ select * from(
28
+ select id,date,complete,profit from report where date like '%2019-01%'
29
+ union all select null,null,sum(complete),sum(profit) from report where date like '%2019-01%'
30
+ ) as sub
23
31
  ```