RANKX Ties

Question

RANKX Ties

Steve Jones - SSC Editor

SSC Guru

Points: 737630
More actions
May 1, 2020 at 12:00 am

#3734238

Comments posted to this topic are about the item RANKX Ties

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

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

kaspencer SSCarpal Tunnel Points: 4910 More actions · Answer 1

Am I allowed to point out that the use of the "Dense" results is in contradiction to the generally preferred, and advised, approach, where a gap equal to one less than the number of shared placements is always added after each rank position.

Might I ask anyone who knows about this: when, or in which disciplines, is this "Dense" ranking approach used?

Thanks

Kenneth Spencer

You never know: reading my book: "All about your computer" might just tell you something you never knew!
lulu.com/kaspencer

George Vobr SSChampion Points: 10056 More actions · Answer 2

Thanks for this question, but is the ranking 1, 2, 2, 4, 5 given in the explanation correct? For the default SKIP, I would expect the ranking 1, 2, 2, 5, 4.

Stewart "Arturius" Campbell SSC Guru Points: 72697 More actions · Answer 3

Nice question, thank Steve

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

Steve Jones - SSC Editor SSC Guru Points: 737630 More actions · Answer 4

The question asks how to get the "3". DENSE will give this.

RANKX Ties

Cookies on SQLServerCentral