Tag: dense_rank
-
Oracle DENSE_RANK function
DENSE_RANK is an Analytical function as well as Aggregate function in Oracle. It returns the rank of the row within the group and it is dense. Syntax (Aggregate function): dense_rank(expression1,expression2,…) WITHIN GROUP (ORDER BY expression1,expression2…) Example :- Find the rank of the employee whose employee number is 18 and salary is 7700 select dense_rank(7700,18) WITHIN GROUP […]