/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 vote191 views1 answer
Restore backup mysql .gz
SQL
2 votes205 views1 answer
Query to find table size in oracle 12c
SQL
0 vote187 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
1 vote251 views1 answer
Backup mysql schema only
SQL
17 votes252 views6 answers
Get last record in sql
SQL
0 vote247 views1 answer
Inner join distinct
SQL
0 vote200 views1 answer
Delete hangfire retries list
SQL
0 vote200 views2 answers
Select last 30 days sql
SQL
0 vote235 views1 answer
SQL get max per id
SQL
11 votes145 views1 answer
Reset identity sql server
SQL