IBM Support

Add PERCENT_RANK as an ordered OLAP specification

News


Abstract

PERCENT_RANK has been added as an ordered OLAP

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > Add PERCENT_RANK as an ordered OLAP specification
PERCENT_RANK returns a relative percentile rank of a row within an OLAP window.
For details, see the SQL Reference: OLAP specifications

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"IBM i 7.4;IBM i 7.3","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
13 January 2020

UID

ibm11146442