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

[ad_1]

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

[ad_2]

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