/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 vote130 views1 answer
How to put is null in where in clause
SQL
1 vote128 views1 answer
How to check the mysql version mac
SQL
0 vote130 views1 answer
Grant privileges mysql to database 1064
SQL
25 votes138 views6 answers
Import database mysql command line
SQL
2 votes121 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote127 views1 answer
Pl sql turn off variable substitution
SQL
3 votes122 views1 answer
Sql replace character in string in all records
SQL
0 vote143 views2 answers
Impala rename column name
SQL
1 vote123 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote126 views1 answer
Show tables in cassandra cql
SQL