Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
aggregates
/
winFnQry_76.q
blob: 264ed7d02c74c44f612681a1b66a36399cee4b97 [
file
] [
log
] [
blame
]
select
c1
,
c2
,
count
(
c1
)
over
(
partition
by
c2 order
by
c1 asc nulls first
)
w_count
from
`tblWnulls.parquet`
where
c2
not
in
(
'a'
,
'b'
,
'c'
);