Analytic

0001-01-01

The OVER Clause: One Result Per Row Without GROUP BY

OVER turns any aggregate into a window function — computing a result across a set of rows while still returning every row intact.