[ https://issues.apache.org/jira/browse/SPARK-28330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-28330: ------------------------------------ Assignee: Apache Spark > ANSI SQL: Top-level <result offset clause> in <query expression> > ---------------------------------------------------------------- > > Key: SPARK-28330 > URL: https://issues.apache.org/jira/browse/SPARK-28330 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.1.0 > Reporter: Yuming Wang > Assignee: Apache Spark > Priority: Major > > h2. {{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: > {noformat} > SELECT select_list > FROM table_expression > [ ORDER BY ... ] > [ LIMIT { number | ALL } ] [ OFFSET number ] > {noformat} > 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 -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org