/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

25 votes279 views4 answers
Sqlserver add column
SQL
4 votes256 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote291 views1 answer
T-sql update table variale
SQL
2 votes267 views1 answer
Oracle apex who is connected
SQL
0 vote265 views1 answer
Call rest api from postgresql
SQL
1 vote273 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote287 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote265 views1 answer
Search column name sql
SQL
0 vote257 views1 answer
SQL isnumeric DB2
SQL
0 vote257 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL