/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 vote129 views1 answer
Ms sql print more than 1 variable
SQL
2 votes200 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote185 views1 answer
Display first three characters sql
SQL
3 votes188 views3 answers
Into in sql
SQL
2 votes219 views1 answer
Oracle insert or update
SQL
0 vote257 views1 answer
How to add auto increment primary key
SQL
0 vote216 views1 answer
Take sql dump in to file
SQL
0 vote180 views1 answer
Pl/sql loop example
SQL
6 votes181 views2 answers
Mysql convert timestamp to date
SQL
0 vote172 views1 answer
1 column values in to 1 single row in sql
SQL