
MySQL
0
Вклад в тег
DATASOURCE_ID: UUID
TIMESTAMP: DATETIME
VALUE: DOUBLE
SELECT *
FROM DATA_TABLE
WHERE
DATASOURCE_ID = :ID AND
TIMESTAMP = (SELECT MAX(TIMESTAMP) FROM DATA_TABLE WHERE DATASOURCE_ID = :ID)