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