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
>id_product year price >1 2004 12004 >1 2003 12003 >2 2003 22003 >2 2002 22002 >>
>id_product year price >1 2004 12004 >2 2003 22003 >>