Try:

DELETE FROM Orders

FROM Orders

INNER JOIN

(

SELECT Order_No, Line_No, MAX(Ship_Date) as MaxShipDate

FROM Orders

GROUP BY Order_No, Line_No

) AS dt

ON Orders.Order_No = dt.Order_No

AND Orders.Line_No = dt.Line_No

AND Orders.Ship_Date <> dt.MaxShipDate