/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 vote150 views1 answer
Create new table in SQL from old table with data
SQL
0 vote190 views2 answers
Insert data into multiple tables mysql
SQL
0 vote148 views1 answer
Sql orcale i forgot what my name & password was
SQL
12 votes194 views6 answers
How to install sqlite3 in python
SQL
0 vote143 views1 answer
How to reset table in sql server
SQL
2 votes141 views1 answer
Sql alchemy or
SQL
0 vote118 views1 answer
Hangfire clean script
SQL
4 votes152 views1 answer
Wilayah indonesia sql
SQL
0 vote151 views1 answer
Resullt all update knex mysql
SQL
0 vote143 views1 answer
Sql count null as 0
SQL