Users Pricing

forum

Home Forums How can I Select data after 7 days interval using SQL Server – MindStick

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

Anonymous User 2358 16 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!

1 Answers

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md