|
|
FULL A - Z Oracle Function Library (formerly named "Morgan's Library")
Term: PERCENT_RANK
Definition: PERCENT_RANK (EXPRESSION) WITHIN GROUP (ORDER BY [EXPRESSION] [ASC | DESC] [NULLS FIRST | NULLS LAST] ) Analytic Usage: PERCENT_RANK() OVER ( PARTITION BY [EXPRESSION] ORDER BY [EXPRESSION] ) Example Usage: SELECT EMPNO, DEPTNO, PERCENT_RANK() OVER(PARTITION BY DEPTNO ORDER_BY SALARY) "% IN DEPT" Related Links: Related Code Snippets:
|
Home | Search | Code Library | Sponsors | Privacy | Terms of Use | Contact Us | © 2003 - 2024 psoug.org |