Query in SQL SERVER2014 for a report (I need the last ROW of a table)
As with most things SQL-related, there is more than one answer in this case. Here is one solution that might work for you. It relies on a lesser known function called "row_number" (Microsoft documentation here) which, in this case, can help you avoid making multiple passes through temp tables (though that would also work for your needs)

;WITH deliveries_report AS (
    SELECT
        id_order ,
        id_Delivery ,
        itemcode ,
        qty,
        ROW_NUMBER()  OVER (PARTITION BY itemcode ORDER BY id_Delivery DESC) AS row_num
    FROM
        #deliveries
    WHERE
        id_order=9
)

SELECT 
    id_order ,
    id_Delivery ,
    itemcode ,
    qty
FROM 
    deliveries_report 
WHERE 
    row_num=1 
ORDER BY 
    id_Delivery DESC    


Just replace #deliveries with the name of your deliveries-table. Good luck!