摘要： select deptno,empno,ename,sal,last_value(sal) over(partition by deptno order by sal ROWS BETWEEN unbounded preceding AND current row ) max_sal,last_value(sal) over(partition by deptno order by sal ) max_sal2,FIRST_VALUE(sal) over(partition by deptno order by sal ROWS BETWEEN unbounded preceding AND 阅读全文