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