Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
tpcds_variants
/
percentrank06.sql
blob: 35633da56a12f9f479d107a7cfcf1ae951a61b1c [
file
] [
log
] [
blame
]
SELECT
PERCENT_RANK
()
OVER
(
PARTITION
BY
s
.
ss_store_sk
,
s
.
ss_customer_sk
ORDER
BY
s
.
ss_store_sk
)
FROM
store_sales s LIMIT
20
;