</>

#lateral-join

1 snippet tagged with #lateral-join

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

#top-n#performance#postgresql