The Dense_Rank function in Oracle SQL / PLSQL is used to return the rank or position of a value in a group of values. It’s very similar to RANK function but RANK function can cause non-consecutive rankings if the tested values are same. The DENSE_RANK function can be used in as an Aggregate and Analytical […]