MySQL Forums
Forum List  »  Newbie

Re: min and max function
Posted by: Peter Brawley
Date: January 31, 2017 03:22PM

The min and max values for that deviceID on day 10 are

select min(value), max(value)
from tmmetercount
where deviceId = x'0a17216927655931bd40b43971aae394' and day(timestamp) = 10 ;

Options: ReplyQuote


Subject
Written By
Posted
January 31, 2017 02:52PM
Re: min and max function
January 31, 2017 03:22PM
January 31, 2017 03:48PM
January 31, 2017 05:50PM
January 31, 2017 08:49PM
January 31, 2017 09:20PM
January 31, 2017 10:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.