Sign in
apache
/
tajo
/
d3ee50a95868a17cd69964adbd3f70149040ab6b
/
.
/
tajo-core
/
src
/
test
/
resources
/
queries
/
TestWindowQuery
/
rowNumber3.sql
blob: 44594c7ec68e924ae434a328e6e838bdb0b53d3f [
file
] [
log
] [
blame
]
SELECT
l_orderkey
,
row_number
()
OVER
(
PARTITION
BY
L_ORDERKEY
)
as
row_num
,
l_discount
,
avg
(
l_discount
)
OVER
(
PARTITION
BY
L_ORDERKEY
)
as
average
FROM
LINEITEM