/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 vote343 views1 answer
How to print out column name differently in mysql
SQL
0 vote354 views1 answer
Convert rows to columns in sql server
SQL
0 vote472 views1 answer
Sql developer export connections
SQL
2 votes366 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
10 votes361 views1 answer
User_dependencies
SQL
1 vote357 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote373 views1 answer
Add sqlcmd to path linux
SQL
0 vote358 views1 answer
Sql count null values in all columns
SQL
12 votes354 views6 answers
Between in sql
SQL
0 vote423 views2 answers
Suse Linux restart MySQL
SQL