質問編集履歴
1
間違い箇所を修正しました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -9,6 +9,18 @@
|
|
|
9
9
|
insert into samp1 (dt,differ) values ("20220603120000",63);
|
|
10
10
|
insert into samp1 (dt,differ) values ("20220602120000",62);
|
|
11
11
|
|
|
12
|
+
select * from samp1;
|
|
13
|
+
+---------------------+--------+
|
|
14
|
+
| dt | differ |
|
|
15
|
+
+---------------------+--------+
|
|
16
|
+
| 2022-06-03 12:00:00 | 63 |
|
|
17
|
+
+---------------------+--------+
|
|
18
|
+
| 2022-06-02 12:00:00 | 62 |
|
|
19
|
+
+---------------------+--------+
|
|
20
|
+
|
|
21
|
+
|
|
22
|
+
ここから、
|
|
23
|
+
当日の分と１日前の分をそれぞれ抜き出し
|
|
12
24
|
|
|
13
25
|
select * from samp1 where dt=20220603120000;
|
|
14
26
|
+---------------------+--------+
|
|
@@ -21,8 +33,9 @@
|
|
|
21
33
|
+---------------------+---------------+
|
|
22
34
|
| dt | differ_past |
|
|
23
35
|
+---------------------+---------------+
|
|
24
|
-
| 2022-06-0
|
|
36
|
+
| 2022-06-03 12:00:00 | 62 |
|
|
25
37
|
+---------------------+---------------+
|
|
38
|
+
|
|
26
39
|
|
|
27
40
|
上記の２つのSELECT文をもとに、下記のように横方向に結合したいです。
|
|
28
41
|
|