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