</>

#top-n

1 snippet tagged with #top-n

sqladvanced

LATERAL Join for Top-N Per Group

Use LATERAL joins to efficiently fetch the top N related rows per group without window function subqueries.

#lateral-join#top-n

Related Topics

#lateral-join#performance#postgresql