/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 vote135 views2 answers
Csv into data postgres
SQL
11 votes172 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote163 views1 answer
In query in sql
SQL
0 vote192 views1 answer
Drop view sql
SQL
3 votes142 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
1 vote138 views1 answer
Python escape mysql
SQL
2 votes150 views4 answers
Sql query interview questions
SQL
2 votes143 views1 answer
Get hour from date sql
SQL
0 vote133 views1 answer
Oracle list of long running queries
SQL
0 vote130 views1 answer
How to connect pgadmin with excel
SQL