• Need help understanding the results of the Top

    Should the output not be 4 records and not 3?

    For ProductID 0f 716 and the order by making 7/1/15 at top there was a quanity ordered of 4 on one record

    SELECT TOP (SELECT TOP 1 OrderQty

    FROM [Sales].[SalesOrderDetail]

    ORDER BY ModifiedDate) *

    FROM [Sales].[SalesOrderDetail]

    WHERE ProductID = 716;