*** 5,10 ****
--- 5,18 ----
below.
----
+ *: 2006.04.07 : ANSI 99 windowing functions:
+
+ SELECT department_id, last_name, salary, commission_pct,
+ RANK() OVER (PARTITION BY department_id
+ ORDER BY salary DESC, commission_pct) comp_rank
+ FROM employees
+ WHERE department_id = 80
+
*: 2006.03.06 : select without left join with the *= operator
SELECT t1.code, t2.code
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|