forum

Home / DeveloperSection / Forums / How can I Select data after 7 days interval using SQL Server

How can I Select data after 7 days interval using SQL Server

Anonymous User198316-Oct-2013

I have a table with Date_Interval in that table have two column. How can I select id's of 7 days interval?

My data is:

date                   id

2013-07-01      11

2013-07-02      22

2013-07-03      33

2013-07-04      33

2013-07-05      44 

2013-07-06      44     

2013-07-07      45 

2013-07-08      46 

2013-07-09      47

2013-07-10      48

2013-07-11      48

2013-07-12      49

2013-07-13      50

2013-07-14      51

2013-07-15      52

2013-07-16      52

2013-07-17      53

2013-07-18      53

2013-07-19      54

How can I do this please suggest me:

date                   id

2013-07-01      11

2013-07-08      46

2013-07-15      52

Thanks!

Updated on 16-Oct-2013
I am a content writter !

Can you answer this question?


Answer

1 Answers

Liked By