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