/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 vote213 views1 answer
Sql value exists in column
SQL
0 vote203 views1 answer
Get first name and last name from full name string in SQL
SQL
2 votes214 views1 answer
How to delete view in sql
SQL
1 vote227 views1 answer
Cross schema query oracle 2 users
SQL
1 vote207 views1 answer
Mysql view command
SQL
32 votes246 views6 answers
Rename column mysql
SQL
2 votes221 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote208 views1 answer
Python mysqlclient library not found for -lssl
SQL
1 vote236 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote215 views1 answer
How to check the port of mysql installation in mac
SQL