Sign in
apache
/
tajo
/
refs/heads/window_function
/
.
/
tajo-core
/
src
/
test
/
resources
/
queries
/
TestWindowQuery
/
testWindowWithSubQuery4.sql
blob: fe32eb1f00034a9a909d8b7e0568545bdb3b8069 [
file
] [
log
] [
blame
]
select
a
.
r_name
,
a
.
r_regionkey
,
row_number
()
over
(
partition
by
a
.
r_regionkey
order
by
a
.
cnt
desc
)
mk
from
(
select
r_name
,
r_regionkey
,
count
(*)
cnt
from
default
.
region
group
by
r_name
,
r_regionkey
)
a
;