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

編集履歴

質問編集履歴

4

SQLを<code>で表現

2019/12/30 12:59

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -44,13 +44,19 @@
44
44
 
45
45
  ■テーブル定義
46
46
 
47
+ ```SQL
48
+
47
49
  create table uriage1 (date timestamp,price double precision);
48
50
 
49
51
  create table uriage2 (date timestamp,price double precision);
50
52
 
53
+ ```
54
+
51
55
 
52
56
 
53
57
  ■データ
58
+
59
+ ```SQL
54
60
 
55
61
  insert into uriage1(date,price) values('20100101',100);
56
62
 
@@ -63,3 +69,5 @@
63
69
  insert into uriage2(date,price) values('2010-01-02 17:00:00',100);
64
70
 
65
71
  insert into uriage2(date,price) values('2010-01-03 17:0:000',200);
72
+
73
+ ```

3

データを追加

2019/12/30 12:59

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -47,3 +47,19 @@
47
47
  create table uriage1 (date timestamp,price double precision);
48
48
 
49
49
  create table uriage2 (date timestamp,price double precision);
50
+
51
+
52
+
53
+ ■データ
54
+
55
+ insert into uriage1(date,price) values('20100101',100);
56
+
57
+ insert into uriage1(date,price) values('20100102',120);
58
+
59
+ insert into uriage1(date,price) values('20100105',130);
60
+
61
+ insert into uriage2(date,price) values('2010-01-01 17:00:00',50);
62
+
63
+ insert into uriage2(date,price) values('2010-01-02 17:00:00',100);
64
+
65
+ insert into uriage2(date,price) values('2010-01-03 17:0:000',200);

2

テーブル定義追加

2019/12/07 09:47

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -44,6 +44,6 @@
44
44
 
45
45
  ■テーブル定義
46
46
 
47
- create table uriage1 (date Date,price double precision);
47
+ create table uriage1 (date timestamp,price double precision);
48
48
 
49
- create table uriage2 (date Date,price double precision);
49
+ create table uriage2 (date timestamp,price double precision);

1

テーブル定義追加

2019/12/07 09:41

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -39,3 +39,11 @@
39
39
  2010-01-02 17:00:00 100
40
40
 
41
41
  2010-01-03 17:00:00 200
42
+
43
+
44
+
45
+ ■テーブル定義
46
+
47
+ create table uriage1 (date Date,price double precision);
48
+
49
+ create table uriage2 (date Date,price double precision);