I have a table with the fields
id, timestamp, value
I want to check all the values are changing for all id’s with the last 48 hours and show the id for the ones that are not changing.
Does anyone know the query I could use to check this ?
I was thinking trying to join two queries, one selecting an hour range of values 48 hours ago and the other selecting the values from the last hour.
However, I am not sure on the details.
Is there a better way ?