/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 vote312 views1 answer
Renommer base sql
SQL
2 votes293 views2 answers
How to DROP a table in mysql
SQL
0 vote303 views1 answer
Sql last time database was accessed
SQL
23 votes334 views5 answers
Sql substring
SQL
0 vote300 views2 answers
Plsql regex match whole word
SQL
0 vote294 views1 answer
Sql query to get column names and data types in sql server
SQL
2 votes319 views1 answer
Postgresql create table as select
SQL
0 vote291 views1 answer
Syntax for changing column size in mysql
SQL
5 votes297 views4 answers
Mysql on duplicate key update
SQL
0 vote284 views1 answer
How to find top 3 salary in sql
SQL