ROW_NUMBER(), RANK(), DENSE_RANK()

What do you mean by ROW_NUMBER(), RANK(), DENSE_RANK() differentiate them?

Questions by samarendra161   answers by samarendra161

Showing Answers 1 - 3 of 3 Answers

asit

  • Jun 9th, 2012
 

THE BELOW FUNCTIONS ARE OLAP FUNCTIONS...

rank() function skips the continuity but dense_rank() function gives the sequence.It is always advised to use dense_rank for viewing nth highest/lowest value. row_num() gives the serial no in the order how they are inserted in to a table.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions