Hello friends, When you want to apply rank to any column without storing it in table. You can use DENSE_RANK