Combine result of 2 queries into 1 result #Merge #subquery


Suppose I have a simple query that looks for measurement results in a certain time range:
SELECT (“value”) FROM measurement WHERE time > ‘2019-09-25T20:00:00Z’ and time < now()

But I want to add 1 extra value: the last value, before that same timerange
SELECT last(“value”) FROM measurement WHERE time < ‘2019-09-25T20:00:00Z

Is it possible to combine those 2 queries into 1, in order to have a 1 array response.

kind regards