Sign in
apache
/
drill
/
0acc6526e021509f817cc4b00ae1923b8583c29b
/
.
/
exec
/
java-exec
/
src
/
test
/
resources
/
window
/
aggregate_range_current_current.sql
blob: d8a66f4d8bc00d06e07ffebada40c2f0ea77ffdd [
file
] [
log
] [
blame
]
SELECT
employee_id
,
position_id
,
sub
,
COUNT
(*)
OVER
(
PARTITION
BY
position_id
ORDER
BY
sub RANGE
BETWEEN
CURRENT
ROW
AND
CURRENT
ROW
)
AS
`
count
`
FROM
%
s