A SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice]) OVER (PARTITION BY [StockSymbol]ORDER BY [TransactionDate] ASC) AS [PreviousPrice]FROM @StockTransactionsORDER BY [StockSymbol], [TransactionDate]
B SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice], 0, NULL) OVER (GROUP BY[StockSymbol] ORDER BY [TransactionDate] ASC) AS [PreviousPrice]FROM @StockTransactionsORDER BY [StockSymbol], [TransactionDate]
C SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice]) OVER (ORDER BY [TransactionDate]ASC) AS [PreviousPrice]FROM @StockTransactionsGROUP BY [StockSymbol]ORDER BY [StockSymbol], [TransactionDate]
D SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice], 0, NULL) OVER (PARTITION BY[StockSymbol] ORDER BY [TransactionDate] ASC) AS [PreviousPrice]FROM @StockTransactionsORDER BY [StockSymbol], [TransactionDate]
E SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice]) OVER (GROUP BY [StockSymbol]ORDER BY [TransactionDate] ASC) AS [PreviousPrice]FROM @StockTransactionsORDER BY [StockSymbol], [TransactionDate]