/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 vote334 views1 answer
Mysql get only the field names in a table
SQL
0 vote367 views1 answer
Mysql where sum > 0
SQL
1 vote349 views2 answers
Oracle list service names
SQL
0 vote348 views1 answer
Insert into table with only identity column
SQL
0 vote335 views1 answer
Radius search with point data in mysql
SQL
0 vote352 views1 answer
Command to give readonly access to a postgres sql user
SQL
1 vote295 views1 answer
Stored procedure return value
SQL
0 vote326 views1 answer
Sql list dates between two dates
SQL
0 vote341 views2 answers
Oracle create tablespace autoextend
SQL
0 vote332 views1 answer
Delete * from where id = 1;
SQL