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