DIff btw row_number and rank_index?

Database
Enthusiast

DIff btw row_number and rank_index?

Hi all,

I would like to know the difference between row_number and rank_index.

Also the diff btw the same when used with partition function.

2 REPLIES
Enthusiast

Re: DIff btw row_number and rank_index?


This is briefly explained at the bottom of this thread.

http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=5&messageid=8112#bm8330
Enthusiast

Re: DIff btw row_number and rank_index?

hi joe,

Thanks for the link. It was useful.