/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

3 votes355 views4 answers
Sql interview questions
SQL
0 vote277 views1 answer
Select all columns except one sql
SQL
0 vote266 views1 answer
Assign value to var in SQL
SQL
0 vote272 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
1 vote285 views1 answer
Mysql alter decimal precision
SQL
1 vote284 views1 answer
Mysql select from outside
SQL
1 vote275 views1 answer
Load mysql dumb
SQL
5 votes322 views2 answers
How to ascending order in sql
SQL
16 votes346 views2 answers
Sql vs nosql
SQL
0 vote279 views1 answer
Normalization in database 2nd normal form
SQL