/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 vote221 views1 answer
Oracle sql winter time change
SQL
0 vote223 views1 answer
Mysql query to add hours to column in table
SQL
0 vote222 views1 answer
Not equal to blank in mysql
SQL
0 vote247 views1 answer
Pgadmin save data greyed out
SQL
0 vote207 views1 answer
How to get n result in sql
SQL
0 vote209 views1 answer
Automate mysql cli query
SQL
0 vote236 views1 answer
Open postgresql.conf in centos
SQL
0 vote234 views1 answer
Oracle sql log to console
SQL
0 vote226 views1 answer
Mysql identified by syntax error
SQL
0 vote427 views1 answer
How to connect .sql data set to powerbi
SQL