Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
multiple_partitions
/
q9.sql
blob: c8962c294def1da8313cc1bca6d877e0767e3277 [
file
] [
log
] [
blame
]
-- Arithmetic operation with two window functions
select
c_date
,
c_time
,
c_integer
,
count
(*)
over
(
partition
by
c_date
ORDER
BY
c_time
)
+
sum
(
c_integer
)
OVER
(
partition
by
c_bigint
order
by
c_time
)
from
j6
where
c_integer
is
not
null
;