/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 vote164 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote115 views1 answer
Sql doesn't contain
SQL
0 vote116 views2 answers
Python mysql create table if not exists
SQL
0 vote106 views1 answer
Retornar apenas o ano mysql date
SQL
5 votes104 views1 answer
Invalid column name sql
SQL
1 vote72 views1 answer
Denied
SQL
1 vote114 views2 answers
Mysql extract month
SQL
4 votes114 views2 answers
Convert utc to est sql
SQL
1 vote107 views1 answer
Sql pick random row
SQL
1 vote107 views1 answer
Oracle start job
SQL