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