1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
select
venuestate,
venueseats,
venuename,
first_value(venuename ignore nulls)
over(partition by venuestate
order by venueseats desc
rows between unbounded preceding and unbounded following) as col_name
from table_name;
SELECT rank () OVER (ORDER BY my_column RANGE BETWEEN 12 FOLLOWING AND CURRENT ROW EXCLUDE NO OTHERS);
SELECT rank () OVER (ORDER BY my_column GROUPS UNBOUNDED PRECEDING EXCLUDE GROUP);
SELECT rank () OVER (ORDER BY my_column RANGE BETWEEN
INTERVAL '1 YEAR - 1 DAYS' PRECEDING AND
INTERVAL '15 DAYS' PRECEDING);
|
