1 2 3 4 5 6 7
| SELECT SUBSTRING(DateTime, 1, 4) AS Annee, SUBSTRING(DateTime, 5, 2) AS Mois, SUBSTRING(DateTime, 7, 2) AS Jour,
SUBSTRING(DateTime, 9, 2) AS Heure, SUBSTRING(DateTime, 11, 2) AS Minute, COUNT(*) AS NbTransactions
FROM MaTable
GROUP BY SUBSTRING(DateTime, 1, 4), SUBSTRING(DateTime, 5, 2), SUBSTRING(DateTime, 7, 2), SUBSTRING(DateTime, 9, 2),
SUBSTRING(DateTime, 11, 2)
ORDER BY SUBSTRING(DateTime, 1, 4), SUBSTRING(DateTime, 5, 2), SUBSTRING(DateTime, 7, 2), SUBSTRING(DateTime, 9, 2),
SUBSTRING(DateTime, 11, 2) |
Partager