Aggregate window functions

• 단순히 max, sum 함수를 사용한 경우

• window max query

WITH brazil_Medals AS(...)

Select 
 Year, Medals,
 MAX(Medals)
	Over(order by year asc) AS MAx_medals
From Brazil_medals;

• Partitioning with aggregate window functions
  • OVER( PARTITION BY variable)

Frames

: Partition, order에 대해서 window function이 작동하는 원리를 바꾸기 위한 하나의 방법론

→ range between unbounded preceding and unbounded following

(범위를 한정해주는 역할을 한다)