/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 vote230 views1 answer
Sql sort ages
SQL
0 vote208 views1 answer
Postgresql using reserved word as column name
SQL
1 vote209 views2 answers
Find nth highest salary of an employee
SQL
9 votes212 views1 answer
Oracle get table schema
SQL
11 votes202 views2 answers
MySQL DISTINCT
SQL
1 vote205 views1 answer
Increase date by one day in sql oracle
SQL
0 vote212 views1 answer
Sql query tags
SQL
1 vote208 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
2 votes226 views1 answer
Ifnull postgres
SQL
0 vote202 views1 answer
Oracle create table auto generated primary key
SQL