/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 vote186 views4 answers
What is unique key in sql
SQL
0 vote177 views1 answer
Alter column to not null with default value sql server
SQL
14 votes186 views3 answers
How to add default constraint in mysql
SQL
1 vote190 views1 answer
Group_concat order by
SQL
3 votes182 views1 answer
APEX elapsed time
SQL
0 vote188 views1 answer
Sql find gaps in date ranges
SQL
0 vote181 views2 answers
Sql stored procedure for access frontend
SQL
0 vote200 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
2 votes172 views1 answer
While loop sql
SQL
5 votes174 views2 answers
Oracle find all tables with column name
SQL