Questões da Prova PUC-PR - 2017 - TJ-MS - Técnico de Nível Superior - Analista de Banco de Dados

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]

FROM @StockTransactions

ORDER BY [StockSymbol], [TransactionDate] 

SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice]) OVER (ORDER BY [TransactionDate]

ASC) AS [PreviousPrice]

FROM @StockTransactions

GROUP BY [StockSymbol]

ORDER BY [StockSymbol], [TransactionDate] 

SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice], 0, NULL) OVER (PARTITION BY

[StockSymbol] ORDER BY [TransactionDate] ASC) AS [PreviousPrice]

FROM @StockTransactions

ORDER BY [StockSymbol], [TransactionDate]  

SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice]) OVER (GROUP BY [StockSymbol]

ORDER BY [TransactionDate] ASC) AS [PreviousPrice]

FROM @StockTransactions

ORDER BY [StockSymbol], [TransactionDate]