The Ranking Function

Question

Post reply

The Ranking Function

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
July 11, 2022 at 12:00 am

#4059316

Comments posted to this topic are about the item The Ranking Function

Viewing 7 posts - 1 through 6 (of 6 total)

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

Toreador SSChampion Points: 11365 More actions · Answer 1

Can anyone think of any real life examples where you'd want to rank over something non-unique?

Scott Mildenberger Ten Centuries Points: 1351 More actions · Answer 2

Toreador wrote:

Can anyone think of any real life examples where you'd want to rank over something non-unique?

Yes. Sales by salesman, salary. I once had a query that ranked truck drivers by many categories individually - miles driven, loads, total revenue, revenue per mile, etc.

ZZartin SSC-Dedicated Points: 30920 More actions · Answer 3

Toreador wrote:

Can anyone think of any real life examples where you'd want to rank over something non-unique?

Sure, this is pretty common when you use it with a meaningful order by. A common example might be something like top sales rep per day, partition by day and order by number of sales.

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 4

Toreador wrote:

Can anyone think of any real life examples where you'd want to rank over something non-unique?

Heh... along with what the others posted, another possible answer is "Interview Question" 😉

--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)

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 5

Great question, Steve.

Another hint here is that there's nothing to guarantee the order within any given rank.

--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)

Jason A. Long SSC-Insane Points: 23786 More actions · Answer 6

Of course, changing the function to DENSE_RANK() and the answer changes to "2 - Lenovo & Samsung".