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 vote231 views1 answer
Oracle lower in where clause
SQL
0 vote244 views2 answers
Greater than sql server
SQL
0 vote211 views1 answer
How to use query in nosql
SQL
3 votes220 views1 answer
Oracle APEX elapsed time
SQL
2 votes226 views1 answer
How to get weekday from old date in sql
SQL
0 vote236 views1 answer
No query unable to fetch row sqlite
SQL
7 votes226 views2 answers
What is sql clause
SQL
0 vote213 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote223 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote212 views1 answer
Cast for print sql
SQL