Sign in
apache
/
tajo
/
refs/heads/window_function
/
.
/
tajo-core
/
src
/
test
/
resources
/
queries
/
TestSQLAnalyzer
/
window9.sql
blob: b289ebf3904931db2771565d3b02b6262915f9dd [
file
] [
log
] [
blame
]
SELECT
dt
,
dt2
,
row_number
()
over
(
window1
),
rank
()
over
(
window1
)
FROM
sum_example
WINDOW
window1
AS
(
partition
by
round
(
dt
),
dt2
order
by
ceil
(
dt
)
asc
null
last
ROWS
BETWEEN
1
PRECEDING
AND
CURRENT
ROW
);