如何在SQL Server中执行take和skip功能

Question

SELECT * FROM Table
OFFSET 10 rows           
FETCH NEXT 15 rows only;

错误为："OFFSET"附近的语法不正确。

Answer 1

您可以阅读本文https://www.sqlservertutorial.net/sql-server-basics/sql-server-offset-fetch/

顺便说一句，您的选择错过了订单例如像这个

SELECT
product_name,
list_price FROM production.products ORDER BY    list_price,    product_name  OFFSET 10 ROWS;