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