Continuous number Segmentation in Oracle

Continuous digital segmentation is required in Oracle

Simulation data:

Fphm JE

1001 20

1002 30

1003 12

1005 32

1006 33

1007 88

1009 99

1010 11

1011 11

As shown in the data, there is an interruption in the middle of the invoice number (FPHM) and we need to segment it by continuity and summarize its amount (JE)

Sql:

Select fphm,fphm-rownum,jefromorder by FPHM

After executing this statement, since RowNum is arranged sequentially, the difference between successive numbers minus rownum should be the same, and we can finally use GROUP by to achieve the goal.

Sql:

Select min (T.FPHM),Max(T.FPHM),sum(t.je) from (Select fphm,fphm-   as tnum,je   from ORDER by FPHM) T Group  by T.TUNM

Continuous number Segmentation in Oracle