Wouldn’t it be offset 4_999_999?
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.johns...@gmail.com>, wrote: > On Monday, November 4, 2024, Guyren Howe <guy...@gmail.com> 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. >
