Oracle rank

-- 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

2 votes124 views1 answer
Enum in SQL Server
SQL
0 vote137 views1 answer
How to check which table has data in mysql
SQL
0 vote131 views1 answer
Take sql dump in to file
SQL
4 votes162 views1 answer
How to check last gather stats on table in oracle
SQL
1 vote124 views1 answer
Truncate left characters mysql
SQL
0 vote118 views1 answer
Mysql date minus 1 day
SQL
0 vote121 views1 answer
Postgres populate table from another table
SQL
16 votes129 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
3 votes170 views1 answer
How to get yesterday date in sql
SQL
0 vote132 views1 answer
Oracle execute package dblink
SQL