/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 vote358 views1 answer
SELECT statement to find the specific cell in database table
SQL
1 vote347 views1 answer
Sql alchemy with azuresql server
SQL
0 vote368 views1 answer
Sql date time query find
SQL
0 vote354 views1 answer
Connect by query in oracle
SQL
0 vote388 views1 answer
Bigrock database connection string
SQL
1 vote358 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
11 votes325 views2 answers
Having keyword sql
SQL
0 vote325 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote358 views3 answers
Sql query checker
SQL
5 votes365 views1 answer
Sysdate in oracle sql
SQL