Answer 1

the difference comes when there are 2 or more records at same position say 3rd and 7th
rank() output - 1,2,3,3,5,6,7,7,7,10
dense_rank() - 1,2,3,3,4,5,6,7,7,7,8