/SQL/Mysql max number not returning correct value

Mysql max number not returning correct value

//This happen due to your comlum donot have interger data type so to relove this
issue there are two ways the first one is change the DATA TYPE to interger

or

another method is to 

SELECT values  FROM  `students` where   id='96' order by cast(values as SIGNED) desc limit 1;

the  cast(values as SIGNED)  will convert the str value into integer value then it will works fine
======CAst example======

https://www.tutorialspoint.com/how-to-get-the-maximum-value-from-strings-with-integers-in-mysql

Similar codes

0 vote163 views1 answer
Mysql collation for all languages
SQL
0 vote204 views1 answer
2020 new year
SQL
11 votes203 views1 answer
Get ddl materialized view oracle
SQL
31 votes217 views3 answers
Sql count
SQL
0 vote202 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote234 views1 answer
Java spring boot connect to sql server
SQL
0 vote276 views3 answers
Select top 10 rows in sql
SQL
5 votes196 views2 answers
Mysqldump password
SQL
0 vote211 views1 answer
Implicit inner join table alias
SQL
1 vote245 views1 answer
Psql client write to bash variable
SQL