Sign in
apache
/
tajo
/
refs/heads/window_function
/
.
/
tajo-core
/
src
/
test
/
resources
/
queries
/
TestWindowQuery
/
testWindowWithAggregation4.sql
blob: af695ba9737b2e46871760024b41b3d67e484248 [
file
] [
log
] [
blame
]
select
l_orderkey
,
count
(*)
as
cnt
,
row_number
()
over
(
order
by
count
(*)
desc
)
row_num
from
lineitem
group
by
l_orderkey