Sign in
apache
/
tajo
/
d3ee50a95868a17cd69964adbd3f70149040ab6b
/
.
/
tajo-core
/
src
/
test
/
resources
/
queries
/
TestWindowQuery
/
testWindowWithSubQuery2.sql
blob: 87520fb8dab7affaef8d5443e774c1212cf88355 [
file
] [
log
] [
blame
]
select
r_name
,
c
,
rank
()
over
(
partition
by
r_regionkey
order
by
r_regionkey
)
as
ran
from
(
select
r_name
,
r_regionkey
,
count
(*)
as
c
from
region
group
by
r_name
,
r_regionkey
)
a
limit
3
;