I'm using Postgresql, but something SQL agnostic would be best. It sounds like you want window functions ... (date, timestamp), timestamp from Table ) group by day If perf matters, make the inner ...