/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

8 votes224 views1 answer
Mysql dump restore
SQL
0 vote171 views1 answer
Sql server query database space available
SQL
0 vote194 views1 answer
Datagrip execute procedure
SQL
0 vote179 views1 answer
Declarative base sqlalchemy
SQL
0 vote184 views1 answer
Returning with sqlalchemy
SQL
0 vote160 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
14 votes187 views1 answer
Oracle new column
SQL
0 vote192 views2 answers
Collation in sql
SQL
1 vote217 views1 answer
Psql client write to bash variable
SQL
0 vote135 views1 answer
Expose db in virtualbox
SQL