10 2013 档案
摘要：一：代码如下：建表：create table test(id number,mc number,sl number)插数：insert into test values(2,110,1);insert into test values(1,111,1);insert into test values(2,555,2);insert into test values(1,222,1);insert into test values(2,333,2);insert into test values(1,666,3);insert into test values(1,333,2);insert i
阅读全文
摘要：SELECTname, salary，CASEWHEN salary = 50000.0 AND salary = 70000.0 AND salary < 100000.0 THEN 'high'ELSE 'very high'END AS bracketFROM employees;
阅读全文
摘要：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
阅读全文
