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