The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

# How can I count the number of values that appear in a given interval?

Hi folks! I would like to partition a row into intervals (say 3-hour intervals), and count the number of entries in each interval. It looks like the time_slice function is the one I'm looking for, but it's not clear to me how to write the query. Any help would be very much appreciated! Josiah

0

## Leave a Comment

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.

## Comments