/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 vote329 views1 answer
Query archive mode
SQL
0 vote347 views1 answer
Sql script get all stored procedures from database
SQL
12 votes322 views2 answers
Delete all nodes neo4j
SQL
0 vote366 views1 answer
Date 3 months from today sql
SQL
0 vote340 views1 answer
Difference between 2 query results sql server
SQL
0 vote339 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote328 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
42 votes410 views6 answers
Install beautifulsoup
SQL
0 vote319 views2 answers
Find Overlapping sql
SQL
8 votes319 views1 answer
Mysql restore database
SQL