/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

6 votes174 views2 answers
Stored procedure to delete data from table in mysql
SQL
21 votes183 views4 answers
Add column mssql
SQL
2 votes163 views1 answer
Oracle virtual column
SQL
6 votes160 views2 answers
Mysql concatenate two columns into one
SQL
1 vote166 views1 answer
Mysql count words
SQL
1 vote170 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote162 views1 answer
Oracle sql log to console
SQL
0 vote157 views1 answer
Sql query to select records entered in last 24 hours
SQL
21 votes173 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote178 views1 answer
How to find total working hour in sql
SQL