1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
;WITH CTE AS (
SELECT
MONTH(ColonneDate) / 4 + 1 AS Trimestre,
YEAR(ColonneDate) AS Annee,
SUM(ColonneIn) OVER(PARTITION BY YEAR(ColonneDate) , MONTH(ColonneDate) / 4 + 1 ) AS SommeIn,
SUM(ColonneOut) OVER(PARTITION BY YEAR(ColonneDate) , MONTH(ColonneDate) / 4 + 1 ) AS SommeOut,
Col1,
Col2,
ROW_NUMBER() OVER (PARTITION BY YEAR(ColonneDate) , MONTH(ColonneDate) / 4 + 1 ORDER BY ColonneDate DESC) AS Rn
FROM LaTable
)
SELECT
Trimestre,
Annee,
SommeIn,
SommeOut,
Col1,
Col2
FROM CTE
WHERE Rn = 1 |
Partager