Sign in
apache
/
drill
/
0acc6526e021509f817cc4b00ae1923b8583c29b
/
.
/
exec
/
java-exec
/
src
/
test
/
resources
/
window
/
last_value_rows_unbounded_current.sql
blob: 5d7eedd4d207664c5451ad91c0671320fcc40287 [
file
] [
log
] [
blame
]
SELECT
employee_id
,
LAST_VALUE
(
employee_id
)
OVER
(
PARTITION
BY
position_id
ORDER
BY
sub
ROWS
BETWEEN
UNBOUNDED
PRECEDING
AND
CURRENT
ROW
)
AS
`
last_value
`
FROM
%
s