I appreciate the SQLServerCentral's effort in dealing with this matter !

select orderid,productID, max(unitprice)

over ( partition by orderid) as MaxPrice

from sales.OrderDetails