/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 vote188 views2 answers
Postgresql change user role grant
SQL
0 vote215 views1 answer
Primary key start from number
SQL
1 vote246 views1 answer
Set statiscis on in sql server
SQL
11 votes241 views1 answer
How to get ddl for materialized view
SQL
0 vote239 views1 answer
Mysql bind-address default value
SQL
0 vote191 views1 answer
SQL column name Oracle
SQL
0 vote206 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
10 votes205 views2 answers
Mysql drop database if exists
SQL
0 vote219 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote304 views1 answer
Import sql dump into postgresql database
SQL