Const
Snowflake grammar facts. TOP n, LIMIT n OFFSET m and OFFSET … FETCH (https://docs.snowflake.com/en/sql-reference/constructs/limit, https://docs.snowflake.com/en/sql-reference/constructs/top_n); RECURSIVE is optional (https://docs.snowflake.com/en/sql-reference/constructs/with); MINUS and EXCEPT are synonyms (https://docs.snowflake.com/en/sql-reference/operators-query); LATERAL (https://docs.snowflake.com/en/sql-reference/constructs/join-lateral); ORDER BY in a subquery applies only there (https://docs.snowflake.com/en/sql-reference/constructs/order-by).
TOP n
LIMIT n OFFSET m
OFFSET … FETCH
Snowflake grammar facts.
TOP n,LIMIT n OFFSET mandOFFSET … FETCH(https://docs.snowflake.com/en/sql-reference/constructs/limit, https://docs.snowflake.com/en/sql-reference/constructs/top_n); RECURSIVE is optional (https://docs.snowflake.com/en/sql-reference/constructs/with); MINUS and EXCEPT are synonyms (https://docs.snowflake.com/en/sql-reference/operators-query); LATERAL (https://docs.snowflake.com/en/sql-reference/constructs/join-lateral); ORDER BY in a subquery applies only there (https://docs.snowflake.com/en/sql-reference/constructs/order-by).