/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

1 vote134 views1 answer
SQLite order random
SQL
0 vote151 views1 answer
Oracle job session
SQL
7 votes135 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote144 views1 answer
Typical max-connect-errors mysql
SQL
19 votes133 views3 answers
Grant mysql
SQL
1 vote162 views3 answers
How to create a table structure from another table in mysql
SQL
1 vote135 views1 answer
Give a column name to values generated from case statement in sql
SQL
10 votes172 views4 answers
Sql server pagination
SQL
0 vote137 views1 answer
Mysql trim characters
SQL
0 vote122 views1 answer
Check if a word appears at the end sql query
SQL