teratail
回答率
85.30%
teratail header banner
teratail header banner
質問するログイン新規登録
トップに関する質問日付のみが一致するものをJOINしたい

編集履歴

質問編集履歴

4

SQLを<code>で表現

2019/12/30 12:59

投稿

退会済みユーザー
title CHANGED
File without changes
body CHANGED
@@ -21,13 +21,17 @@
21
21
  2010-01-03 17:00:00 200
22
22
 
23
23
  ■テーブル定義
24
+ ```SQL
24
25
  create table uriage1 (date timestamp,price double precision);
25
26
  create table uriage2 (date timestamp,price double precision);
27
+ ```
26
28
 
27
29
  ■データ
30
+ ```SQL
28
31
  insert into uriage1(date,price) values('20100101',100);
29
32
  insert into uriage1(date,price) values('20100102',120);
30
33
  insert into uriage1(date,price) values('20100105',130);
31
34
  insert into uriage2(date,price) values('2010-01-01 17:00:00',50);
32
35
  insert into uriage2(date,price) values('2010-01-02 17:00:00',100);
33
- insert into uriage2(date,price) values('2010-01-03 17:0:000',200);
36
+ insert into uriage2(date,price) values('2010-01-03 17:0:000',200);
37
+ ```

3

データを追加

2019/12/30 12:59

投稿

退会済みユーザー
title CHANGED
File without changes
body CHANGED
@@ -22,4 +22,12 @@
22
22
 
23
23
  ■テーブル定義
24
24
  create table uriage1 (date timestamp,price double precision);
25
- create table uriage2 (date timestamp,price double precision);
25
+ create table uriage2 (date timestamp,price double precision);
26
+
27
+ ■データ
28
+ insert into uriage1(date,price) values('20100101',100);
29
+ insert into uriage1(date,price) values('20100102',120);
30
+ insert into uriage1(date,price) values('20100105',130);
31
+ insert into uriage2(date,price) values('2010-01-01 17:00:00',50);
32
+ insert into uriage2(date,price) values('2010-01-02 17:00:00',100);
33
+ insert into uriage2(date,price) values('2010-01-03 17:0:000',200);

2

テーブル定義追加

2019/12/07 09:47

投稿

退会済みユーザー
title CHANGED
File without changes
body CHANGED
@@ -21,5 +21,5 @@
21
21
  2010-01-03 17:00:00 200
22
22
 
23
23
  ■テーブル定義
24
- create table uriage1 (date Date,price double precision);
24
+ create table uriage1 (date timestamp,price double precision);
25
- create table uriage2 (date Date,price double precision);
25
+ create table uriage2 (date timestamp,price double precision);

1

テーブル定義追加

2019/12/07 09:41

投稿

退会済みユーザー
title CHANGED
File without changes
body CHANGED
@@ -18,4 +18,8 @@
18
18
  date 　price
19
19
  2010-01-01 17:00:00 50
20
20
  2010-01-02 17:00:00 100
21
- 2010-01-03 17:00:00 200
21
+ 2010-01-03 17:00:00 200
22
+
23
+ ■テーブル定義
24
+ create table uriage1 (date Date,price double precision);
25
+ create table uriage2 (date Date,price double precision);