i have a database with fields as: StartDate, LocationID, EmployeeID, Equipment
all in a table named: Table1
i found the following code to filter the data, getting the max "StartDate" field and displaying the remainder fields. which works fine... as long as all the multiple location's latest start date is the same date, which it will not be.
Code: Select all
SELECT * FROM "Table1" WHERE "StartDate" = ( SELECT MAX( "StartDate" ) FROM "Table1" )