Pular para o conteúdo principal

Questão de Banco de Dados — SQL Server — PUC-PR 2017

Banco de DadosSQL Server
Código
qq295258
Banca
PUC-PR
Órgão
TJ-MS
Ano
2017
Nível
Superior
Cargo
Técnico de Nível Superior - Analista de Banco de Dados
Dada uma estrutura de variáveis do tipo tabela, conforme abaixo, no SQL Server 2012, com os dados de amostra fornecidos:Imagem associada para resolução da questão
  1. ASELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice]) OVER (PARTITION BY [StockSymbol]ORDER BY [TransactionDate] ASC) AS [PreviousPrice]FROM @StockTransactionsORDER BY [StockSymbol], [TransactionDate]
  2. BSELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice], 0, NULL) OVER (GROUP BY[StockSymbol] ORDER BY [TransactionDate] ASC) AS [PreviousPrice]FROM @StockTransactionsORDER BY [StockSymbol], [TransactionDate]
  3. CSELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice]) OVER (ORDER BY [TransactionDate]ASC) AS [PreviousPrice]FROM @StockTransactionsGROUP BY [StockSymbol]ORDER BY [StockSymbol], [TransactionDate]
  4. DSELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice], 0, NULL) OVER (PARTITION BY[StockSymbol] ORDER BY [TransactionDate] ASC) AS [PreviousPrice]FROM @StockTransactionsORDER BY [StockSymbol], [TransactionDate]
  5. ESELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice]) OVER (GROUP BY [StockSymbol]ORDER BY [TransactionDate] ASC) AS [PreviousPrice]FROM @StockTransactionsORDER BY [StockSymbol], [TransactionDate]
Revelar gabarito e comentário

GabaritoA — SELECT [StockSymbol], [TransactionDate], [StockPrice], LAG([StockPrice]) OVER (PARTITION BY [StockSymbol] ORDER BY [TransactionDate] ASC) AS [PreviousPrice] FROM @StockTransactions ORDER BY [StockSymbol], [TransactionDate]

Link permanente: /questoes/qq295258