Sign in
apache
/
drill
/
0acc6526e021509f817cc4b00ae1923b8583c29b
/
.
/
exec
/
java-exec
/
src
/
test
/
resources
/
window
/
q3.sql
blob: d6875face6b5088469dd97f3e69a7169c1284de3 [
file
] [
log
] [
blame
]
SELECT
position_id
,
employee_id
,
LAST_VALUE
(
employee_id
)
OVER
(
PARTITION
BY
position_id
ORDER
by
employee_id
RANGE
BETWEEN
UNBOUNDED
PRECEDING
AND
UNBOUNDED
FOLLOWING
)
AS
`
last_value
`
FROM
dfs
.`
window
/
b4
.
p4
`