Sign in
apache
/
tajo
/
refs/heads/window_function
/
.
/
tajo-core
/
src
/
test
/
resources
/
queries
/
TestWindowQuery
/
testWindowWithOrderBy5.sql
blob: 2dc87af6fb4ce0c62514f3e45d2909e680622028 [
file
] [
log
] [
blame
]
SELECT
l_orderkey
,
l_partkey
,
rank
()
OVER
(
ORDER
BY
l_orderkey
)
r1
,
rank
()
OVER
(
ORDER
BY
l_partkey
desc
)
r2
FROM
LINEITEM
where
l_partkey
>
0
and
l_partkey
<
100
;