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 );