Hi - I have a requirement to find the count of records for every 7 day interval. is there any window function I can use to get the count for the following sample data and result set? Please help
s_no Date of transaction
101 01/01/2015
101 01/03/2015
101 01/03/2015
101 01/04/2015
101 01/05/2015
101 01/10/2015
101 01/12/2015
101 01/12/2015
101 01/14/2015
101 01/15/2015
101 01/17/2015
Result
7_day interval cnt
01/07/2015 5
01/14/2015 4
01/21/2017 2