/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

1 vote332 views4 answers
How to check table in postgresql from terminal
SQL
6 votes292 views2 answers
Non relational database
SQL
2 votes292 views2 answers
Storing timezones in postgres
SQL
7 votes293 views4 answers
Lowest salary in sql
SQL
0 vote278 views1 answer
Sql count total by foreign key
SQL
1 vote275 views1 answer
Count mysql server db tables
SQL
2 votes262 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote259 views1 answer
Sql python hwo to pass a list in paramerter
SQL
1 vote304 views1 answer
Sql set auto increment back to 0
SQL
0 vote291 views1 answer
Limit in access query
SQL