質問編集履歴
1
説明の修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -6,15 +6,15 @@
|
|
6
6
|
|
7
7
|
◯deviceIDが0001
|
8
8
|
|
9
|
-
◯timeが
|
9
|
+
◯timeが指定した期間内
|
10
10
|
|
11
11
|
◯上記2つを満たした中でreceive_levelが最小のもの
|
12
12
|
|
13
13
|
|
14
14
|
|
15
|
-
以下の命令文だと何も取り出すことができない状態です。
|
15
|
+
以下の命令文だと何も取り出すことができない状態です。timeのBETWEENは条件を満たしています。
|
16
16
|
|
17
|
-
SELECT * FROM position_log where (receive_level,deviceID,time) in (select min(receive_level),deviceID=0001,time BETWEEN (NOW() - INTERVAL
|
17
|
+
SELECT * FROM position_log where (receive_level,deviceID,time) in (select min(receive_level),deviceID=0001,time BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW() from position_log WHERE `deviceID`=0001 and time BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW())
|
18
18
|
|
19
19
|
|
20
20
|
|