/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 vote254 views1 answer
How to change mysql port in xampp
SQL
0 vote247 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
7 votes243 views1 answer
Forge server hosting
SQL
0 vote241 views1 answer
Backup a table in sql
SQL
11 votes250 views2 answers
Mysql disable safe mode
SQL
4 votes287 views2 answers
Postgresql float data type
SQL
0 vote259 views1 answer
Postgresql certain first 4 characters in string
SQL
1 vote290 views1 answer
Oracle show execution plan
SQL
8 votes266 views2 answers
Between operator
SQL
0 vote258 views1 answer
Postgresql print variable
SQL