/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

1 vote239 views1 answer
Drop df constraint sql server
SQL
0 vote210 views0 answer
SQL
0 vote266 views1 answer
Sql cursor example multiple columns
SQL
19 votes239 views5 answers
Change column name mysql command line
SQL
0 vote244 views1 answer
Mysql sum with group by
SQL
0 vote232 views2 answers
Mysql multiply
SQL
1 vote281 views2 answers
Laravel jwt generate token
SQL
3 votes375 views6 answers
Sql unique select
SQL
0 vote245 views1 answer
Sql server convert to guid
SQL
0 vote240 views1 answer
Geopoint from json mysql function
SQL