/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 vote374 views2 answers
Import data from excel to sql server automatically
SQL
11 votes373 views1 answer
Creating tables in sql with python
SQL
0 vote344 views1 answer
Sqlite löschen einer tabelle
SQL
1 vote354 views3 answers
Nth highest salary
SQL
1 vote351 views1 answer
Get create table query existing table mysql
SQL
4 votes345 views3 answers
Employee name starting with in sql
SQL
1 vote352 views1 answer
Postgresql define pk sequence next number
SQL
0 vote349 views1 answer
Sql ignore
SQL
1 vote322 views2 answers
Find a column in all tables mysql
SQL
1 vote346 views3 answers
Union in sql
SQL