Database Reference
In-Depth Information
TVA_TAUX FLOAT)
INSERT INTO T_TVA VALUES
('Super Réduit', '1982-07-01', 5.50),
('Super Réduit', '1989-01-01', NULL),
('Réduit', '1968-01-01', 6.38),
('Réduit', '1968-12-01', 7.53),
('Réduit', '1970-01-01', 7.50),
('Réduit', '1973-01-01', 7.00),
('Réduit', '1989-01-01', 5.50),
('Intermédiaire', '1968-01-01', 14.92),
('Intermédiaire', '1968-12-01', 15.65),
('Intermédiaire', '1970-01-01', 17.60),
('Intermédiaire', '1982-07-01', NULL),
('Normal', '1968-01-01', 20.00),
('Normal', '1968-12-01', 23.46),
('Normal', '1970-01-01', 23.00),
('Normal', '1973-01-01', 20.00),
('Normal', '1977-01-01', 17.60),
('Normal', '1982-07-01', 18.60),
('Normal', '1995-08-01', 20.60),
('Normal', '2000-04-01', 19.60),
('Majoré', '1968-01-01', 25.00),
('Majoré', '1968-12-01', 33.33),
('Majoré', '1989-01-01', 28.00),
('Majoré', '1989-09-15', 25.00),
('Majoré', '1991-01-01', 22.00),
('Majoré', '1993-01-01', NULL);
CREATE VIEW V_TVA AS
SELECT TVA_TYPE, TVA_DATE_APPLICATION AS TVA_DATE_DEBUT_
APPLICATION,
COALESCE((SELECT MIN(TVA_DATE_APPLICATION) - 1 DAY
FROM T_TVA AS T2
WHERE T1.TVA_TYPE = T2.TVA_TYPE
AND T1.TVA_DATE_APPLICATION< T2.TVA_DATE_APPLICATION),
'9999-12-31')
AS TVA_DATE_FIN_APPLICATION, TVA_TAUX
FROM T_TVA AS T1;
