Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
multiple_partitions
/
q21.sql
blob: cd60112cceaf88abfb820db58a1aa59dafab06c0 [
file
] [
log
] [
blame
]
-- Multiple window defintions
select
sum
(
c_integer
)
over
w1
,
count
(*)
over
w2
from
j1
window w1
as
(
order
by
c_date
),
w2
as
(
partition
by
c_bigint
order
by
c_date
,
c_time
)
;