1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| create table MaTable
( id integer
, dt_deb date
, dt_fin date
, libelle varchar(10)
, valeur varchar(10)
);
insert into MaTable values
(1, '2015-01-01', '2019-01-01', 'grade' , 'secrétaire'),
(1, '2019-01-01', '2099-12-31', 'grade' , 'directrice'),
(1, '2015-01-01', '2018-01-01', 'service', 'service_1' ),
(1, '2018-01-01', '2099-12-31', 'service', 'service_2' ),
(2, '2016-01-01', '2019-01-01', 'grade' , 'secrétaire'),
(2, '2019-01-01', '2021-01-01', 'grade' , 'directrice'),
(2, '2022-01-01', '2099-12-31', 'grade' , 'directrice'),
(2, '2015-01-01', '2020-01-01', 'service', 'service_1' ),
(2, '2020-01-01', '2023-01-01', 'service', 'service_2' ); |
Partager