LIMIT and OFFSET clauses
Description
The LIMIT and OFFSET clauses retrieves and skips the number of rows specified in the number.
The LIMIT and OFFSET clauses are fully supported in Snowflake.
Grammar Syntax
[ LIMIT { number | ALL } ]
[ OFFSET start ]Sample Source Patterns
LIMIT number
Input Code:
SELECT id, name, manager_id, salary
INTO limited_employees
FROM employee
LIMIT 5;Output Code:
CREATE TABLE IF NOT EXISTS limited_employees AS
SELECT id, name, manager_id, salary
FROM
employee
LIMIT 5;LIMIT ALL
Input Code:
SELECT id, name, manager_id, salary
INTO limited_employees
FROM employee
LIMIT ALL;Output Code:
CREATE TABLE IF NOT EXISTS limited_employees AS
SELECT id, name, manager_id, salary
FROM
employee
LIMIT NULL;OFFSET without LIMIT
Snowflake doesn't support OFFSET without LIMIT. The LIMIT is added after transformation with NULL, which is the default LIMIT.
Input Code:
SELECT id, name, manager_id, salary
INTO limited_employees
FROM employee
OFFSET 5;Output Code:
CREATE TABLE IF NOT EXISTS limited_employees AS
SELECT id, name, manager_id, salary
FROM
employee
LIMIT NULL
OFFSET 5;Known Issues
There are no known issues.
Related EWIs.
There are no related EWIs.
Last updated