The identical rank is assigned on the rows which have the identical values. The ranks inside the RANK() perform may not be consecutive because it assigns the same rank to rows with equivalent values. This gets rid of the additional do the job of making sure that the ideal graphic https://catgeneralcontractingllc.com