Oracle分析函数与开窗函数 order by partition by

1. 创建数据表partition_by_test
SQL> CREATE TABLE partition_by_test (NAME VARCHAR(20) NOT NULL, PAR NUMBER);
SQL> INSERT INTO partition_by_test VALUES (‘CAR’,10000);
SQL> INSERT INTO partition_by_test VALUES (‘CAR’,20000);
SQL> INSERT INTO partition_by_test VALUES (‘CAR’,30000);
SQL> INSERT INTO partition_by_test VALUES (‘VAN’,40000);
SQL> INSERT INTO partition_by_test VALUES (‘VAN’,30000);
SQL> INSERT INTO partition_by_test VALUES (‘VAN’,10000);
SQL> INSERT INTO partition_by_test VALUES (‘VAN’,50000);
SQL> INSERT INTO partition_by_test VALUES (‘BUS’,90000);
SQL> INSERT INTO partition_by_test VALUES (‘BUS’,20000);
SQL> INSERT INTO partition_by_test VALUES (‘BUS’,40000);
SQL> INSERT INTO partition_by_test VALUES (‘BUS’,60000);
SQL> COMMIT;
SQL> SELECT * FROM partition_by_test;

<

NAME	PAR