Find a SQL

lianchan

There is a table as follows
num1 num2 date
  1 2 20160329
  1 2 20160329
  1 2 20160329
  1 2 20160330
  1 2 20160401
...

Now I want to write a query to find the sum of num1 and num2 every 7 days. Please ask everyone to write a Sql and explain the idea.

onlysnake

Every 7 days, do you mean 7 days a month, or any 7 days?

陈奕城

Table partitions are summarized, and the granularity of the summary is based on the amount of data every 7 days

kusoler

select sum(num1), sum(num2) where datediff(date1, date2)=7

date1, date2 are two dates