Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
aggregates
/
winFnQry_81.q
blob: 8307de49c29f7c6a9b7656bb3c0f954f4529d96b [
file
] [
log
] [
blame
]
select
c1
,
c2
,
w_sum
from
(
select
c1
,
c2
,
sum
(
c1
)
over
(
partition
by
c2 order
by
c1 asc nulls first
)
w_sum
from
`tblWnulls.parquet`
)
sub_query
where
w_sum
is
not
null
;