SQL Server 中的前 5 行

Question

在 SQL Server 中，下面哪些查询能返回 Product 表中最贵的 5 件产品？请选出所有正确的选项。

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

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