/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

2 votes182 views1 answer
Check isolation level in mysql
SQL
1 vote159 views1 answer
Mssql string length
SQL
3 votes207 views2 answers
How to delete git repo locally
SQL
3 votes211 views2 answers
Wp do sql query from function
SQL
0 vote183 views1 answer
Delete double on SQL with multiple primary keys
SQL
4 votes189 views1 answer
Sql data types
SQL
0 vote193 views1 answer
SQL Query to delete all the tables in a database
SQL
11 votes202 views2 answers
How to import mysql database command line
SQL
3 votes190 views2 answers
Sql random integer
SQL
0 vote194 views1 answer
Alasql delete column
SQL