1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| CREATE TABLE T_TAUX_TAX
(TAX_ID INTEGER NOT NULL PRIMARY KEY,
TAX_DATE_DEBUT DATETIME NOT NULL,
TAX_TAUX FLOAT NOT NULL)
INSERT INTO T_TAUX_TAX VALUES (1, '20040101', 123.45)
INSERT INTO T_TAUX_TAX VALUES (2, '20050915', 129.99)
INSERT INTO T_TAUX_TAX VALUES (3, '20060101', 130.50)
CREATE VIEW V_TAUX_TAX
AS
SELECT T1.TAX_ID, T1.TAX_DATE_DEBUT AS TAX_DATE_DEBUT,
COALESCE(MIN(T2.TAX_DATE_DEBUT), '99991231') AS TAX_DATE_FIN,
T1.TAX_TAUX
FROM T_TAUX_TAX T1
LEFT OUTER JOIN T_TAUX_TAX T2
ON T1.TAX_DATE_DEBUT < T2.TAX_DATE_DEBUT
GROUP BY T1.TAX_ID, T1.TAX_DATE_DEBUT, T1.TAX_TAUX |
Partager