You can find the Minimum and Maximum values in a column using SQL.
min()
- https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html
- https://www.w3schools.com/sql/func_mysql_min.asp
max()
- https://www.w3schools.com/sql/func_mysql_max.asp
- https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html
Select min(temp) from temp;
Select min(temp), max(temp), avg(temp) from temp;
Select min(temp) from temp where macAddress = macAddress=‘60bbbaa4ae30’;
Select macAddress, min(temp), max(temp), avg(temp) from temp group by macAddress;
Be the first to comment