The CUME_DIST ranking

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715910

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

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71401

    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: 16865

    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: 994682

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

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

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