Select * from (
select ARTICOLO, MOV_ID, RANK () OVER (PARTITION BY ARTICOLO ORDER BY MOV_DATE DESC) AS RANGO
 from (
SELECT  articolo, MOV_id, mov_date FROM MOVIMENTI -- where mov_date .... ti resta solo da selezionare i records con mov_date uguale al mese precedente
))
Where RANGO=1