Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 02nd, 2009
DENSE_RANK() OVER (<query_partition_clause><order_by_clause>)
conn oe/oe
SELECT d.department_name, e.last_name, e.salary,DENSE_RANK()
OVER (PARTITIONBY e.department_id ORDERBY e.salary)ASDENSE_RANKFROM employees e, departments d
WHERE e.department_id = d.department_id
AND d.department_id IN(30,60);