Posted by strawberry on 10/13/85 11:43

I think this is right...

SELECT propertyid, MAX( valuationdate ) , valuation
FROM properties
GROUP BY propertyid

[Back to original message]