/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 vote274 views1 answer
Crontab every month
SQL
8 votes306 views1 answer
Oracle add auto_increment column to existing table
SQL
1 vote295 views1 answer
Sql server select rows by distinct column
SQL
0 vote283 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote303 views2 answers
How to take recent row without limit in mysql
SQL
0 vote339 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote313 views1 answer
Datatables server side filter where clause
SQL
3 votes286 views1 answer
Ssh check mysql version
SQL
0 vote306 views1 answer
SQL Server date literal
SQL
0 vote294 views1 answer
Get who is hired in month in sql
SQL