ORACLE 按记录数均匀分组

2019独角兽企业重金招聘Python工程师标准>>>

1、统计需要分组的数据量

2、算出每组的数据量

3、按分组的关键字处理，获取到每个分组的边界

select trunc(N_ORDER / 556601) as F_SN, max(t.l_custno) as l_custno

  from (select t.*, row_number() over(order by l_custno) N_ORDER

          from temp_lucre_shares t) t

 group by trunc(N_ORDER / 556601)

 order by trunc(N_ORDER / 556601);

4、每个分组就是select a.l_custno from temp_lucre_shares a where a.l_custno >=first_custno and a.l_custno <end_custno

转载于:https://my.oschina.net/henryzhou/blog/74052