/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 vote110 views1 answer
Sql script to remove default from column
SQL
0 vote108 views1 answer
Openquery update linked server
SQL
4 votes117 views1 answer
Oracle nls_date_format
SQL
0 vote107 views1 answer
PSQL qith variables
SQL
0 vote105 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
1 vote110 views3 answers
Psql fatal database does not exist
SQL
0 vote130 views1 answer
Oracle step procedure
SQL
6 votes134 views3 answers
Rename column ORACLE
SQL
1 vote98 views1 answer
Mysql show current queries
SQL
2 votes58 views4 answers
Mysql change database character set to utf8mb4
SQL