General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Records matching MAX(Date)
Hi
Can I, in 1 SELECT statement, achieve the following:
Table1 contains fields PK = Primary Key, FK = Foreign Key, Date = Date.
I need to obtain the records from the table that have the highest date entry, do I need to select the dates first and then include those results in a sub-query in a 2nd Select?
Any ideas?
Thanks
Kev
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only