Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-23908

Implement SELECT ... OFFSET ... FETCH ...

    XMLWordPrintable

    Details

      Description

      The 2008 SQL standard introduced the following syntax:

      OFFSET start { ROW | ROWS }
      FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES }
      

      See https://www.postgresql.org/docs/13/sql-select.html#SQL-LIMIT for a description.

      This would also allow does not include the non-standard LIMIT WITH TIES.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              cvicentiu Vicențiu Ciorbaru
              Reporter:
              greenman Ian Gilfillan
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: