Try

SELECT id_product, year, price ;
	FROM mytable mt1 ;
	WHERE year IN ( SELECT MAX(year) FROM mytable mt2
			 WHERE mt2.id_product = mt1.id_product ) 

>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?
>TIA