Wouldn’t it be offset 4_999_999?
I’d still like to understand why nth_value doesn’t work.
I’d still like to understand why nth_value doesn’t work.
On 4 Nov 2024 at 15:44 -0800, David G. Johnston <david.g.johnston@xxxxxxxxx>, wrote:
On Monday, November 4, 2024, Guyren Howe <guyren@xxxxxxxxx> wrote:
I’m trying to get the id of the 5,000,000th record, so I can join against it to get a name. I didn’t fully understand what the docs say there. What am I missing?So just use “offset 5_000_000 limit 1”. Bringing in a window function here seems unhelpful.David J.
