Difference between rownum and rank function

Database
Fan

Difference between rownum and rank function

Hi gurus,

I need to know the difference between rownum and rank function
Tags (2)
1 REPLY

Re: Difference between rownum and rank function


The ROW_NUMBER function always assigns discrete numbers to each row, unlike
RANK which can produce tied results.