[Solved] mySQL Fetch the row which has the Max value for a column

by


First, you shouldn’t name your column update, choose another name, let’s say “date_of_update”

If you want to select only the row with the most recent update, you can simply use something like this : 

SELECT * FROM table_name ORDER BY date_of_update DESC LIMIT 1.

This will give you only one row with the max date!

0

solved mySQL Fetch the row which has the Max value for a column