4 D_PERIODE_CAGZ

Frédérik Benoist edited this page 2023-12-12 08:18:46 +01:00

XG

SELECT 2022, COUNT (*) FROM d_periode_cagz WHERE jour_id BETWEEN 20220101 AND 20221231
union
SELECT 2023, COUNT (*) FROM d_periode_cagz WHERE jour_id BETWEEN 20230101 AND 20231231
union
SELECT 2024, COUNT (*) FROM d_periode_cagz WHERE jour_id BETWEEN 20240101 AND 20241231
union
SELECT 2025, COUNT (*) FROM d_periode_cagz WHERE jour_id BETWEEN 20250101 AND 20251231;

insert into d_periode_cagz SELECT * FROM dwh.d_periode_cagz@PMOSAI WHERE jour_id BETWEEN 20240101 AND 20241231;