Aggregate window functions are used to perform operations on sets of rows in a window(s). They include SUM() , MAX() , COUNT() , and others. Rank window functions are used to rank rows in a window(s).