/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 vote310 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote295 views1 answer
Lister les index d'une table oracle
SQL
2 votes318 views1 answer
Grant revoke privileges to mysql username
SQL
1 vote329 views1 answer
Size of all tables in a schema oracle
SQL
0 vote298 views6 answers
Unique key in sql
SQL
14 votes340 views2 answers
Oracle limit rows
SQL
0 vote324 views1 answer
Sql server select record with max id
SQL
1 vote330 views1 answer
Name of today sql
SQL
1 vote325 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
2 votes366 views2 answers
Set value to null sql
SQL