Is there any particular scenario wherein using RANK() is preferred over DENSE_RANK()? RANK() skips a rank if the previous one is repeated, so then why should one use it?
