Query to Return Latest Dated Records Among Like Key Fields 2

[StarPassing]

Need a query that will return the latest dated record among like key fields.
Example:

Para Grade Date
1 85 04/01/04
2 92 03/28/04
1 91 03/26/04
3 90 04/02/04
2 85 03/29/04

The query should return the following.

Para Grade Date
1 85 04/01/04
2 85 03/29/04
3 90 04/02/04

Thanks

 

[jksmi]

Hi,

presuming that Para and Date are unique it might look something like this:

SELECT	Table1.Date, Table1.Para, Table1.Grade
FROM	Table1 INNER JOIN (
SELECT	Max(Table1.Date) AS MaxOfDate, Table1.Para
FROM	Table1
GROUP	BY Table1.Para) AS d1
	ON	(Table1.Date = d1.MaxOfDate)
	AND	(Table1.Para = d1.Para);

Otherwise you'll need to use SELECT DISTINCT or DISTINCTROW or something, would need more info...
Hope this help, Jamie

 

[StarPassing]

Works great. Thanks.