/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 views1 answer
Where name ends in SQL
SQL
0 vote295 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote314 views1 answer
Postgres populate table from another table
SQL
10 votes291 views4 answers
Primary key sql
SQL
1 vote305 views1 answer
How to group by month using sql server
SQL
1 vote309 views3 answers
Update from select sqlite
SQL
1 vote307 views1 answer
Operator does not exist: integer = text
SQL
3 votes287 views1 answer
Sql several or
SQL
0 vote289 views1 answer
Go install mysql
SQL
1 vote306 views1 answer
Postgres install unaccent extension
SQL