Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 02nd, 2009
NTILE(<expression>) OVER ([query_partition_clause]<order BY clause>)
col ename format a30
col department_name format a20
SELECT*FROM(SELECT e.ffirst_name ||' '|| e.last_name ENAME, d.department_name,
e.salary,TRUNC(e.salary -AVG(e.salary) OVER (PARTITIONBY
FROM employees e, departments d
WHERE e.department_id=d.department_id)WHERE sal_dif >0ORDERBY2,4DESC;
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.