
What is difference between dense_rank and rank function

AnswerBot
1mo

dense_rank assigns consecutive ranks to rows with the same value, while rank leaves gaps in ranking.
dense_rank assigns the same rank to rows with the same value, while rank leaves gaps in ranking
dense...read more

Help your peers!
Add answer anonymously...
Popular interview questions of Data Engineer
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app