描述
OFFSET 子句用于在返回结果前跳过指定数量的行，通常与 LIMIT 和 ORDER BY 一起使用。示例
-- LIMIT + OFFSETSELECT * FROM VALUES (1),(2),(3),(4),(5) AS t(id) ORDER BY id LIMIT 3 OFFSET 1-- OFFSET onlySELECT * FROM VALUES (1),(2),(3) AS t(id) ORDER BY id OFFSET 2
OFFSET 子句用于在返回结果前跳过指定数量的行，通常与 LIMIT 和 ORDER BY 一起使用。-- LIMIT + OFFSETSELECT * FROM VALUES (1),(2),(3),(4),(5) AS t(id) ORDER BY id LIMIT 3 OFFSET 1-- OFFSET onlySELECT * FROM VALUES (1),(2),(3) AS t(id) ORDER BY id OFFSET 2
