/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

25 votes140 views6 answers
Import database mysql command line
SQL
0 vote133 views1 answer
Download mysql database to excel in android studio
SQL
10 votes121 views4 answers
Primary key in sql
SQL
0 vote129 views1 answer
Postgres can integer fields be negative
SQL
0 vote157 views1 answer
Varchar2 length in oracle
SQL
0 vote131 views1 answer
Nvl2 syntax
SQL
0 vote125 views1 answer
Lost connection to mysql
SQL
0 vote135 views1 answer
Postgresql not in alternative
SQL
0 vote129 views1 answer
Postgres drop type
SQL
0 vote142 views1 answer
Limit in access query
SQL