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

0 vote324 views1 answer
Order by number of character in sql
SQL
2 votes351 views1 answer
Removing view
SQL
0 vote372 views1 answer
Get total and distict row diff in sql
SQL
0 vote422 views1 answer
How to check foreign key constraint in sql
SQL
1 vote324 views3 answers
Postgresql connect to database
SQL
0 vote433 views1 answer
Drop table BigQuery table columns
SQL
0 vote365 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
5 votes349 views5 answers
Sqlite install python
SQL
0 vote331 views1 answer
How to convert DateTime to VarChar SQL
SQL
1 vote331 views1 answer
PLS-00225 type
SQL