Sign in
apache
/
drill-test-framework
/
HEAD
/
.
/
framework
/
resources
/
Functional
/
window_functions
/
aggregates
/
wPrtnOrdrBy_8.q
blob: 1cfbf028e1244b842f13b0b10af9dc6feefb02c9 [
file
] [
log
] [
blame
]
SELECT col_vchar_52
,
col_int
,
PERCENT_RANK
()
OVER
(
PARTITION BY col_vchar_52 order
by
col_int
)
prcnt_rank FROM
`smlTbl.parquet`
WHERE col_vchar_52
=
'GXXXXXXXXXXXXXXXXXXXXXXXXXHXXXXXXXXXXXXXXXXXXXXXXXXI'
;