Les 5 premières lignes dans SQL Server

Question

Lesquelles de ces requêtes renvoient les 5 produits les plus chers de la table Product dans SQL Server ? Choisissez toutes les réponses qui conviennent.

Answer 1

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

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 OFFSET 0 ROWS FETCH NEXT 5 ROWS ONLY;

Answer 4

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

Answer 5

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