Ultimo registro

[GeriReshef]

Intentá así:

Código SQL:

WITH T AS
(SELECT ROW_NUMBER() OVER(Partition BY ItemCode ORDER BY ShipDate DESC) N,
    *
FROM    POR1)
SELECT  *
FROM    T
WHERE   N=1;