lead() over(partition by ) lag() over(partition by ) row_number() over(partition by order by ) NTILE() over() count(*) over() max() over() min() over() PERCENT_RANK() over()