>I need a query to extract the most recent price inserted for a product
>i.e.
>
>
>id_product year price
>1 2004 12004
>1 2003 12003
>2 2003 22003
>2 2002 22002
>
>
>so as to obtain
>
>id_product year price
>1 2004 12004
>2 2003 22003
>
>
>
>Which is the SQL syntax to perform the Select?
YOu need to do this in two steps:
SELECT id_product, MAX(year) AS MostRecent ;
FROM YourTable ;
GROUP BY 1 ;
INTO CURSOR Recent
SELECT id_product, Year, Price ;
FROM YourTable ;
JOIN Recent ;
ON YourTable.id_product = Recent.Id_product ;
AND YourTable.Year = Recent.MostRecent ;
INTO CURSOR Result
Tamar