offset n rows fetch next m rows only with dummy order by column - consistent results? RRS feed

  • Frage

  • the "Offset n rows fetch m rows only" clause only works with an specified "order by" - which of course makes the query slower than without order.

    My co-worker and me tried ordering by a constant:

    select 0 as SORT_DUMMY, p.* from table p order by 1 Offset 0 rows fetch next 10 only

    the command runs without Problems, however - I am not sure, if this would return the rows in a reproducable manner (we are using this for pagination).

    Anybody has any insights on this?


    Johannes Colmsee

    Dienstag, 18. Oktober 2016 11:43