Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
aggregates
/
aggOWnFn_39.q
blob: 35dde894c1dec8244845c95de3a41d5d63396c5c [
file
] [
log
] [
blame
]
SELECT MIN
(
lastVal_col1
)
FROM
(
SELECT LAST_VALUE
(
col1
)
OVER
(
PARTITION BY col7 ORDER BY col1
)
lastVal_col1
,
col7 FROM
`allTypsUniq.parquet`
)
sub_query
;