Tag: SQL Rank

• April 18, 2012

  Oracle RANK function

  RANK is an Analytical function as well as Aggregate function in Oracle. It returns the rank of the row within the group. Syntax (Aggregate function): 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 rank(7700,18) WITHIN GROUP (ORDER BY salary,empno) as […]