/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 vote199 views1 answer
FIND most frequent word in sql server
SQL
2 votes299 views3 answers
Postgres create view
SQL
11 votes197 views1 answer
Ddl materialized view
SQL
0 vote201 views1 answer
Rename view mysql
SQL
0 vote187 views1 answer
Mql5 list all available symbols
SQL
1 vote210 views1 answer
How to see all table partition in oracle
SQL
1 vote195 views1 answer
Trigger in postgresql to change incoming entry
SQL
1 vote252 views1 answer
Create index concurrently postgres
SQL
0 vote197 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
7 votes231 views3 answers
Sql server check if temp table exists
SQL