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

1 vote205 views2 answers
Intersect sql
SQL
0 vote162 views1 answer
Get cpu details sql
SQL
0 vote261 views1 answer
Mysql select field if condition
SQL
3 votes157 views2 answers
Oracle apex charging debug
SQL
1 vote205 views1 answer
Insert pg result of select
SQL
0 vote183 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
11 votes165 views1 answer
How to get ddl for materialized view
SQL
0 vote155 views1 answer
Dapper run sql script with parameters
SQL
0 vote115 views1 answer
Update set with join pl sql
SQL
0 vote167 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL