Top 5 Rows in SQL Server

Question

Which of these queries return the 5 most expensive products from the Product table in SQL Server? Choose all that apply.

Answer 1

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

Answer 2

SELECT Name, ListPrice FROM Product ORDER BY ListPrice DESC FETCH FIRST 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 Name, ListPrice FROM Product ORDER BY ListPrice DESC LIMIT 5;

Answer 5

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