Dada uma estrutura de variáveis do tipo tabela, conforme abaixo, no SQL Server 2012, com os dados de amostra fornecidos:
SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice]) OVER (PARTITION BY [StockSymbol]
ORDER BY [TransactionDate] ASC) AS [PreviousPrice]
FROM @StockTransactions
ORDER BY [StockSymbol], [TransactionDate]
SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice], 0, NULL) OVER (GROUP BY
[StockSymbol] ORDER BY [TransactionDate] ASC) AS [PreviousPrice]
SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice]) OVER (ORDER BY [TransactionDate]
ASC) AS [PreviousPrice]
GROUP BY [StockSymbol]
SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice], 0, NULL) OVER (PARTITION BY
SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice]) OVER (GROUP BY [StockSymbol]
Olá, para continuar, precisamos criar uma conta! É rápido e grátis.
