PostgreSql聚合函数二---聚合函数，分析函数和窗口函数

PostgreSql的窗口函数使用
文档中涉及的表的结构和数据：
1. 表emp_detail：
create table emp_detail(
 empno integer,
 ename varchar(10),
 sal numeric,
 dept_no integer,
 time_stamp date
 );
 
 insert into emp_detail values(7369,'SMITH',100);
 
 insert into emp_detail values(7369,'SMITH',100,20,'2015-04-01');
 insert into emp_detail values(7369,'SMITH',105,20,'2015-04-02');
 insert into emp_detail values(7369,'SMITH',120,20,'2015-04-03');
 insert into emp_detail values(7369,'SMITH',150,20,'2015-04-04');
 insert into emp_detail values(7369,'SMITH',200,20,'2015-04-05');
 insert into emp_detail values(7369,'SMITH',400,20,'2015-04-06');
 insert into emp_detail values(7369,'SMITH',180,20,'2015-04-07');


2. 表Student：
create table student(
  id int,
  stu_name varchar(50),
  chinese numeric,
  english numeric,
  math    numeric
  );
  
  insert into student values(1001,'小明',80,75,90);
  insert into student values(1002,'小红',70,75,85);
  insert into student values(1003,'小强',80,90,100);


3. 表emp：
CREATE TABLE public.emp (
  empno INTEGER,
  ename VARCHAR(10),
  job VARCHAR(9),
  mgr INTEGER,
  hiredate TIMESTAMP(6) WITHOUT TIME ZONE,
  sal DOUBLE PRECISION,
  comm DOUBLE PRECISION,
  dept_no INTEGER
);




INSERT INTO public.emp ("empno", "ename", "job", "mgr", "hiredate", "sal", "comm", "dept_no")
VALUES (7369, E'SMITH', E'CLERK', 7902, E'1980-12-17 00:00:00', 800, NULL, 20);


INSERT INTO public.emp ("empno", "ename", "job", "mgr", "hiredate", "sal", "comm", "dept_no")
VALUES (7499, E'ALLEN', E'SALESMAN', 7698, E'1981-02-20 00:00:00', 1600, 306, 30);


INSERT INTO public.emp ("empno", "ename", "job", "mgr", "hiredate", "sal", "comm", "dept_no")
VALUES (7521, E'WARD', E'SALESMAN', 7698, E'1981-02-22 00