Could someone shed more light on the following code? What kind of scenario can this be used in a real world?
SELECT TOP (SELECT TOP 1 OrderQty
FROM [Sales].[SalesOrderDetail]
ORDER BY ModifiedDate) *
FROM [Sales].[SalesOrderDetail]
WHERE ProductID = 716;
-----------------------------------------------------------------------
Known is a DROP, Unknown is an OCEAN.:ermm: