Hello, i want to know how can one perform order by ASC and DESC both in different subqueries. Influd doesn’t allow to do this. Is there any workaround for this ?
i have 3 subqueries one that select value before a certain timestamp, one that select values between timestamps and last that select value after certain timestamp
- for first subquery DESC is good because i want last value
- for third i want ASC because i want most recent value