/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

5 votes155 views1 answer
Find table from column name in sql
SQL
4 votes146 views1 answer
What are the data types in sql
SQL
0 vote158 views1 answer
Sql server list table sizes
SQL
1 vote142 views1 answer
How to delete a record from sqlite in android
SQL
2 votes200 views1 answer
Get the mysql table columns data type mysql
SQL
4 votes158 views3 answers
Sqlite show columns
SQL
0 vote152 views1 answer
Dapper run sql script with parameters
SQL
0 vote154 views1 answer
Plpgsql raise notice
SQL
0 vote145 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote150 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL