以下是我的创表语句
create table HR_GBXCBZB1
(
ID NUMBER(10) not null,
DJ NUMBER(5) not null,
DC NUMBER(5) not null,
GZ NUMBER(10),
VERSION NUMBER(5) not null
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table HR_GBXCBZB1
is '劳资基本薪酬标准表1';
-- Add comments to the columns
comment on column HR_GBXCBZB1.DJ
is '工资等级';
comment on column HR_GBXCBZB1.DC
is '工资档次';
comment on column HR_GBXCBZB1.GZ
is '工资';
comment on column HR_GBXCBZB1.VERSION
is '薪酬版本';
-- Create/Recreate primary, unique and foreign key constraints
alter table HR_GBXCBZB1
add constraint HR_GBXCBZB1 primary key (ID)
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
最终查询的结果要类似这样的,我想了好久,也没有想到办法,求助各位大神了,分不多,不好意思各位
最后面是我的数据,比较多
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (1, 23, 1, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (2, 23, 2, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (3, 23, 3, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (4, 23, 4, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (5, 23, 5, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (6, 23, 6, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (7, 23, 7, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (8, 23, 8, 6075, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (9, 23, 9, 6190, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (10, 23, 10, 6305, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (11, 23, 11, 6420, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (12, 23, 12, 6535, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (13, 23, 13, 6650, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (14, 23, 14, 6765, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (15, 23, 15, 6880, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (16, 23, 16, 6995, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (17, 23, 17, 7110, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (18, 23, 18, 7225, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (19, 23, 19, 7340, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (20, 23, 20, 7455, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (21, 23, 21, 7570, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (22, 23, 22, 7685, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (23, 23, 23, 7800, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (24, 23, 24, 7915, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (25, 22, 1, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (26, 22, 2, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (27, 22, 3, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (28, 22, 4, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (29, 22, 5, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (30, 22, 6, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (31, 22, 7, null, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (32, 22, 8, 5440, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (33, 22, 9, 5540, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (34, 22, 10, 5640, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (35, 22, 11, 5740, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (36, 22, 12, 5840, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (37, 22, 13, 5940, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (38, 22, 14, 6040, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (39, 22, 15, 6140, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (40, 22, 16, 6240, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (41, 22, 17, 6340, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (42, 22, 18, 6440, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (43, 22, 19, 6540, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (44, 22, 20, 6640, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (45, 22, 21, 6740, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (46, 22, 22, 6840, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (47, 22, 23, 6940, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (48, 22, 24, 7040, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (49, 21, 1, 4390, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (50, 21, 2, 4485, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (51, 21, 3, 4580, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (52, 21, 4, 4675, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (53, 21, 5, 4770, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (54, 21, 6, 4865, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (55, 21, 7, 4960, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (56, 21, 8, 5055, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (57, 21, 9, 5150, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (58, 21, 10, 5245, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (59, 21, 11, 5340, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (60, 21, 12, 5435, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (61, 21, 13, 5530, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (62, 21, 14, 5625, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (63, 21, 15, 5720, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (64, 21, 16, 5815, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (65, 21, 17, 5910, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (66, 21, 18, 6005, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (67, 21, 19, 6100, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (68, 21, 20, 6195, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (69, 21, 21, 6290, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (70, 21, 22, 6385, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (71, 21, 23, 6480, 2);
insert into hr_gbxcbzb1 (ID, DJ, DC, GZ, VERSION)
values (72, 21, 24, 6575, 2);