The same rank is assigned for the rows that have precisely the same values. The ranks is probably not consecutive while in the RANK() operate mainly because it provides the number of repeated rows towards the repeated rank to compute the rank of another row. ISDATE() functionality : This functionality https://logiccolony.com