• something like this:-

    SELECT SUM(UnitPrice)

    FROM

    (SELECT TOP 3 UnitPrice FROM Sales.SalesOrderDetail

    ORDER BY ModifiedDate DESC )t