/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

18 votes193 views6 answers
Create table mysql
SQL
8 votes203 views4 answers
How to calculate the age from date of birth in python
SQL
19 votes240 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote198 views2 answers
Postgres another version
SQL
103 votes2.5K views1 answer
Like sql
SQL
1 vote191 views1 answer
Oracle apex prevent initial load
SQL
1 vote189 views1 answer
Reutrn string after character sql
SQL
0 vote210 views1 answer
Make parameters nullable in sql server
SQL
0 vote195 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
3 votes182 views1 answer
Start mysql server linux terminal
SQL