Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
aggregates
/
aggOWnFn_23.q
blob: b751431ea7f2cd0ec9840cb47b953cb2ef6bdd93 [
file
] [
log
] [
blame
]
SELECT COUNT
(
lag_c1
)
FROM
(
SELECT LAG
(
c1
)
OVER
(
PARTITION BY c2 ORDER BY c1
)
lag_c1
,
c2 FROM
`tblWnulls.parquet`
)
sub_query
;