ETL Row number, Rank and Dense Rank

What is row number, rank and dense rank? What are its uses?

Showing Answers 1 - 3 of 3 Answers

nithish

  • Oct 26th, 2016
 

rownum wiil give the sequence numbers and rank will work to skip the rows but coming to dense rank does not skip the rows for ex
we have data like this
sno name salary rowno rank dense_rank
1 nithish 10000 1 1 1
2 anju, 20000 2 2 2
3 danial 30000 3 3 3
4 john 30000 4 3 3
5 prem 50000 5 5 4
6 cruiz, 29000 6 6 5
7 blake, 29000 7 6 5
8 andy 40000 8 8 6

  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