drop table HL_NPACB_bak;
CREATE TABLE HL_NPACB_bak
( AGE NUMBER(8,0),
SEX NUMBER(8,0),
PAYENDYEAR NUMBER(8,0),
POLYEAR NUMBER(8,0),
DVDL NUMBER(16,8),
DVDM NUMBER(16,8),
DVDH NUMBER(16,8)
);
insert into HL_NPACB_bak
select * from HL_NPACB;
-- 1 110880 5.27398358585859 20.3588616522367 35.4437382756133
select count(*),avg(DVDL), avg(DVDM), avg(DVDH) from HL_NPACB_bak;
-- 1 55440 5.27398358585859 20.3588616522367 35.4437382756133
select count(*),avg(DVDL), avg(DVDM), avg(DVDH) from HL_NPACB;
drop table HL_NPACB;
CREATE TABLE HL_NPACB
( AGE NUMBER(8,0),
SEX NUMBER(8,0),
PAYENDYEAR NUMBER(8,0),
POLYEAR NUMBER(8,0),
DVDL NUMBER(16,8),
DVDM NUMBER(16,8),
DVDH NUMBER(16,8),
primary key (age, sex, payendyear, polyear)
);
insert into HL_NPACB (age, sex, PayEndyear, polyear, dvdl, dvdm, dvdH)
select distinct age, sex, PayEndyear, polyear, dvdl, dvdm, dvdH
from HL_NPACB_bak;