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