In my DB table, I have 4 columns in which there is one "LastUpdate" column. Data inside this column is as below:
2014-05-13 03:20:00
2014-05-26 10:00:00
2014-05-13 12:45:00
2014-05-20 01:01:00
I want to get data from this table based on "most LastUpdate value".
I tried this query:
SELECT LastUpdate, abstraction, abstraction2, Level FROM Table DeletionDate is null order by LastUpdate desc LIMIT 1;
But it is giving me the last value. which is not my requirement.
I want to get values based on most Last updated datetime value.
Please reply