/SQL/Rank function in oracle with example

Rank function in oracle with example

-- Employees per department, ranked in salary order
SELECT EMPNO,
       DEPTNO,
       SAL,
       rank() OVER (PARTITION BY DEPTNO ORDER BY SAL) AS MYRANK
FROM EMP;

Source: oracle-base.com

Similar codes

15 votes259 views4 answers
T-sql drop function if exists
SQL
1 vote245 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
17 votes281 views6 answers
Change column name in sql
SQL
9 votes246 views2 answers
Default number in sql
SQL
1 vote268 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote302 views1 answer
Show all sequences postgres
SQL
1 vote292 views1 answer
Show databases mysql docker
SQL
0 vote262 views1 answer
How to find sql server name
SQL
1 vote267 views1 answer
List all triggers in SQL Server
SQL
103 votes451 views1 answer
Like sql
SQL