LATERAL

0001-01-01

LATERAL JOIN for Top-N Per Group

LATERAL lets the right-hand subquery reference columns from the left side — enabling top-N per group in a single scan without window functions and outer filters.