Description
LIMIT and OFFSET
LIMIT and OFFSET allow you to retrieve just a portion of the rows that are generated by the rest of the query:
SELECT select_list FROM table_expression [ ORDER BY ... ] [ LIMIT { number | ALL } ] [ OFFSET number ]
If a limit count is given, no more than that many rows will be returned (but possibly fewer, if the query itself yields fewer rows). LIMIT ALL is the same as omitting the LIMIT clause, as is LIMIT with a NULL argument.
OFFSET says to skip that many rows before beginning to return rows. OFFSET 0 is the same as omitting the OFFSET clause, as is OFFSET with a NULL argument.
If both OFFSET and LIMIT appear, then OFFSET rows are skipped before starting to count the LIMIT rows that are returned.
https://www.postgresql.org/docs/11/queries-limit.html
Feature ID: F861
Attachments
Issue Links
- is duplicated by
-
SPARK-40258 Spark does not support pagination
-
- Resolved
-
- is related to
-
SPARK-3998 Add offset limit to SqlParser.scala
-
- Closed
-
- links to