1USE AdventureWorks2016;
2GO
3SELECT Ord.SalesOrderID, Ord.OrderDate,
4 (SELECT MAX(OrdDet.UnitPrice)
5 FROM Sales.SalesOrderDetail AS OrdDet
6 WHERE Ord.SalesOrderID = OrdDet.SalesOrderID) AS MaxUnitPrice
7FROM Sales.SalesOrderHeader AS Ord;
8GO