/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 vote414 views3 answers
Characters found after end of sql statement
SQL
2 votes364 views1 answer
Column names in oracle sql
SQL
6 votes357 views5 answers
Alter table oracle
SQL
0 vote375 views1 answer
Psql list rules
SQL
2 votes357 views1 answer
Oracle find unusable indexes
SQL
8 votes365 views2 answers
Oracle auto increment primary key
SQL
0 vote352 views1 answer
Limit and offset in stored procedure mssql
SQL
17 votes360 views6 answers
Get last record in sql
SQL
0 vote370 views1 answer
Set a default value for a column in sqlite
SQL
13 votes364 views6 answers
Mysql update from select
SQL