top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is the difference between Row_Number and Rank in Oracle and in which place we can use them

+4 votes
3,108 views
What is the difference between Row_Number and Rank in Oracle and in which place we can use them
posted Feb 18, 2014 by Neeraj Pandey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

RANK rates two rows as eqaul in an event of tie, whereas ROW_NUMBER treats them as different with unique running serial number provided to each record.

answer Feb 23, 2014 by Prachi Agarwal
...