/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

4 votes110 views4 answers
Print pl sql
SQL
2 votes143 views2 answers
Install postgresql
SQL
0 vote114 views1 answer
Sql missing values
SQL
0 vote123 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
1 vote113 views1 answer
Find logged in users mysql
SQL
0 vote120 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote115 views1 answer
Set column in all row mysql
SQL
0 vote137 views1 answer
Drop all data from tables
SQL
0 vote110 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote153 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL