/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 vote118 views1 answer
Mysql show long running queries
SQL
0 vote124 views3 answers
Run sql command line
SQL
0 vote128 views1 answer
Get rows from 1 table with other table empty mysql
SQL
-1 vote141 views1 answer
Ms sql select datetime as date
SQL
1 vote114 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote129 views1 answer
Python mysql show databases
SQL
2 votes123 views1 answer
Oracle sql merge
SQL
1 vote111 views1 answer
Psql datetime grather than
SQL
1 vote120 views1 answer
How to select rows with no matching entry in another table?
SQL
5 votes127 views2 answers
Postgresql insert select
SQL