> or use a lateral subquery to surgically (fetch first 1) retrieve the first row when sorted by recency descending.
I'm not sure that I see how to apply this when I need top-k, not top-1.
Fetch first k
It's just a modern limit clause.
David J.
> or use a lateral subquery to surgically (fetch first 1) retrieve the first row when sorted by recency descending.
I'm not sure that I see how to apply this when I need top-k, not top-1.
|