/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 vote189 views1 answer
Select from column mysql
SQL
1 vote244 views2 answers
Begin transaction sql
SQL
0 vote167 views1 answer
Zsh: command not found: mysql mamp
SQL
1 vote178 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote177 views1 answer
Sql composite key
SQL
0 vote212 views1 answer
Doctors appointment
SQL
0 vote175 views1 answer
Contraint default SQL
SQL
0 vote188 views1 answer
Delete a record from a table sqlite3
SQL
0 vote174 views1 answer
Composit key in sql
SQL
0 vote188 views1 answer
Mysql min value row
SQL