Oracle SQL advanced query, analysis function FUNC over (partition by col [, order B

 e.ename,e.job,e.sal,e.deptno  scott.emp e,( e.deptno,(e.sal) sal  scott.emp e   e.deptnomaxe.deptno  e.sal e.ename,e.job,e.sal,e.deptno,rank  e.ename,e.job,e.sal,e.deptno,rank() (partition  e.deptno   e.sal ) rank  e.rank e.ename,e.job,e.sal,e.deptno  ( e.ename,e.job,e.sal,e.deptno,  (e.sal) (partition  e.deptno   e.sal)   e.sal(e.sal) (partition  e.deptno),(e.sal) (partition  e.deptno   e.sal) ,) diff_max_sal  e.ename,e.sal,lead(e.sal,)  (partition  e.deptno   e.sal)  e.ename,e.sal,e.deptno,(e.sal) (partition  e.deptno   e.ename ) max_sal  e.ename,e.sal,(e.sal) (partition  e.deptno   e.sal ) max_sal ,) (partition  e.deptno  ,) (partition  e.deptno   (partition  e.deptno   e.sal) e.sal , (partition  e.deptno   e.sal) e.sal,) diff_lag_sal  (partition (partition (e.sal) (partition (e.sal)  (partition (e.sal) (partition (partition  e.deptno   e.sal) row_num  scott.emp e;

Http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions001.htm#sthref964