/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 vote155 views1 answer
Postgres enumerated type
SQL
10 votes109 views2 answers
Django mysql
SQL
1 vote160 views1 answer
Convert epoch to date in sql server
SQL
1 vote165 views1 answer
Events mysql
SQL
6 votes142 views1 answer
Rank function in oracle with example
SQL
0 vote156 views1 answer
Pl/ sql change currency
SQL
13 votes207 views3 answers
Sql select from multiple tables without join
SQL
0 vote158 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
11 votes180 views4 answers
Reset identity column values in sql server
SQL
1 vote159 views1 answer
Postgres convert exisiting column to text
SQL