1 2 3 4 5 6 7 8 9 10 11 12
| select "ETABLISSEMENT", "DATE_COMPTABLE", "D_MOIS", "D_CACLE", "LIBELLE_CA", "D_TCODE", "LIBELLE_TCODE", "D_NATURE_CHARGES", SUM("SOLDE")
from (
select "D_PHASE_ANNEE", "ETABLISSEMENT", "DATE_COMPTABLE", "D_MOIS", "D_CACLE", "LIBELLE_CA", "D_TCODE", "LIBELLE_TCODE", "D_NATURE_CHARGES", "SOLDE", ROW_NUMBER () OVER () "ROWNUM"
from "REEL"."TABLE1"
where "D_CACLE" like '260XXX'
and "D_PHASE_ANNEE" like 'Réalisé 2023'
and TO_NUMBER(substr("D_MOIS", 2, 2), 'S0000000D00') between 1 and 12
and "D_NATURE_CHARGES" like 'PP11'
) x
WHERE "ROWNUM" between 1 and 1000
GROUP BY "D_PHASE_ANNEE", "ETABLISSEMENT", "DATE_COMPTABLE", "D_MOIS", "D_CACLE", "LIBELLE_CA", "D_TCODE", "LIBELLE_TCODE", "D_NATURE_CHARGES"
ORDER BY "D_MOIS" DESC |
Partager