PGSQL 动态计算

SELECT 部门,入职月份, 入职人数,
sum(入职人数) over (order by 入职月份 rows between unbounded preceding and current row),
sum(入职人数) over (order by 入职月份 range between unbounded preceding and current row) as 当月人数累计
  FROM hr_growth_rate;

 

将入职人数，顺序累加，每一行都是前面N行之和加上当前行，按入职月份分组

下面是创建索引，用一次字后将索引初始值改成1

DROP SEQUENCE if EXISTS "public"."hrcount_id_seq";  
CREATE SEQUENCE "public"."hrcount_id_seq"  
 INCREMENT 1  
 MINVALUE 1  
 MAXVALUE 9223372036854775807    
 START 1  
 CACHE 1;  

ALTER SEQUENCE hrcount_id_seq RESTART WITH 1;