The CUME_DIST ranking

Question

The CUME_DIST ranking

Steve Jones - SSC Editor

SSC Guru

Points: 736105
More actions
July 12, 2019 at 12:00 am

#3659003

Comments posted to this topic are about the item The CUME_DIST ranking

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Stewart "Arturius" Campbell SSC Guru Points: 72621 More actions · Answer 1

Nice, easy question to end the week on, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

call.copse SSCoach Points: 18046 More actions · Answer 2

I enjoyed Kathi's article on the difference between PERCENT_RANK and CUME_DIST, as always a good write up from her.

Jeff Moden SSC Guru Points: 1004301 More actions · Answer 3

Heh... I wonder how many people won't even try to answer because the test data is done using a cCTE to build a Tally Table and they don't know how it works. I hope those people use this question to learn what it does.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)