SQL Server – "Denali" – PERCENT_RANK() Analytic Function(beyondrelational.com)
submitted by
jacobsebastian(3639) 8 months, 25 days ago
PERCENT_RANK() returns the position of a row within the result set. In contrast to RANK() function, PERCENT_RANK() ranks rows between 0 and 1, both inclusive. Computation formula used by PERCENT_RANK(): (RANK() – 1) / (Number of Rows – 1)...
|category: Database
|Views: 3
tags:
Database another
Everyones tags:
Your Tags: