Tag: SQL Rank
-
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 […]