/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 vote178 views1 answer
Mysql wsrep ls
SQL
1 vote138 views1 answer
Duplicating a MySQL table with all the data Command
SQL
37 votes150 views3 answers
Duplicate records in sql
SQL
0 vote189 views1 answer
Example database query
SQL
0 vote100 views1 answer
Plsql trigger insert update
SQL
0 vote148 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
18 votes167 views2 answers
Sql comments
SQL
5 votes146 views2 answers
Ranking functions in sql
SQL
2 votes147 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote140 views1 answer
Rabbitmq service not starting
SQL