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

I think this is right...

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

• Next in forum: Re: Can it be done ?
• Prev in forum: Re: Query on subrecords
• Thread view: Re: Can it be done ?

[Reply to this message]