SQL get the last date time record [duplicate]
If you want one row for each filename, reflecting a specific states and listing the most recent date then this is your friend:
select filename , status , max_date = max( dates )from some_table tgroup by filename , statushaving status = '<your-desired-status-here>'Easy!
SELECT * FROM tableWHERE Dates IN (SELECT max(Dates) FROM table);
SELECT TOP 1 * FROM foo ORDER BY Dates DESCWill return one result with the latest date.
SELECT * FROM foo WHERE foo.Dates = (SELECT MAX(Dates) FROM foo)Will return all results that have the same maximum date, to the milissecond.
This is for SQL Server. I'll leave it up to you to use the DATEPART function if you want to use dates but not times.