#1297

SELECT d.department_name, e.last_name, e.salary, 
DENSE_RANK() OVER (PARTITION BY e.department_id ORDER BY e.salary) AS drank
FROM employees e, departments d

DEPARTMENT_NAME LAST_NAME SALARY DRANK
———————– —————— ———- ———-
Purchasing Colmenares 2500 1
Purchasing Himuro 2600 2
Purchasing Tobias 2800 3
Purchasing Baida 2900 4
Purchasing Khoo 3100 5
Purchasing Raphaely 11000 6
Human Resources Marvis 6500

database, oracle

[Oracle] Row to Column conversion [Java] Extract ZIP file