OFFSET ... FETCH, I'm having I'm getting...interesting results.
Here are two sqlfiddles to illustrate my problem.
The first fiddle is the first page, while the second is the...second page.
Here are the unpaginated results.
First thing, the paginated results are not in the same order as the unpaginated results. I'm cool with that, I guess, as I'm not showing the unpaginated results anyway.
However, event though I'm specified an offset of 0, and for some reason it decided to put them in the reverse order they were entered, it skips the first 3.
On the second page, I see see results that appear on the first page.
The fact that they all have the same value, although in this example is contrived, is a reality in the specific query I'm dealing with in real life. It's a table, and the user selected to sort by