As 5 Primeiras Linhas no SQL Server

Question

Quais destas consultas devolvem os 5 produtos mais caros da tabela Product no SQL Server? Escolha todas as que se aplicam.

Answer 1

SELECT TOP (5) Name, ListPrice FROM Product ORDER BY ListPrice DESC;

Answer 2

SELECT Name, ListPrice FROM Product OFFSET 0 ROWS FETCH NEXT 5 ROWS ONLY;

Answer 3

SELECT Name, ListPrice FROM Product ORDER BY ListPrice DESC FETCH FIRST 5 ROWS ONLY;

Answer 4

SELECT Name, ListPrice FROM Product ORDER BY ListPrice DESC LIMIT 5;

Answer 5

SELECT Name, ListPrice FROM Product ORDER BY ListPrice DESC OFFSET 0 ROWS FETCH NEXT 5 ROWS ONLY;