lundi 9 mars 2015

In SQL, how can I count rows grouping into certain intervals, if I only know the length of those intervals?

Let's say that my first column is time. What I want is to be able to count the rows grouping them by an arbitrary time range, for instance: by day, by hour, by 20 minutes intervals, by 15 seconds etc.


Aucun commentaire:

Enregistrer un commentaire